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
button
 
 

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
button
 


Edit the DataSource View