Need help selecting specific combinations of dimension values - kbutterly |
09-May-08 07:42:31
|
Good morning, all.
Running AS 2005.
I have an account number, which is made up of four different
dimensions: Department, Resource, Project and Code, in the format
Department-Resource-Project-Code and I'm trying to return two
measures: Actual and Budget.
The users want to be able to select two accounts, e.g. 111-25-F12-523
and 123-85-876-621 and get just the measures for those values, not the
measures for all combinations of those values. For example, if I only
had two dimensions, if I wanted results for 111-25 and 123-85 and
passed in 111 and 123 for Department and 25 and 85 for Resource, I
would get results for 111-25 and 111-85 and 123-25 and 123-85.
Can someone point me to where I need to go to get a sample of how to
do this? Or maybe the correct terminology to describe what I want to
do, so that I can do some searching?
Thanks,
Kathryn |
 |
| |
|
|
| |
Need help selecting specific combinations of dimension values - kbutterly |
15-May-08 12:30:47
|
for archival purposes, the only way to do this apparently is to create
an account dimension with values such as 1112F12523 and 12385876621.
Kathryn |
 |
| |
|
|