If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Question on Dimesional Function

Started by rpvs, 07 Jul 2011 04:51:32 PM

Previous topic - Next topic

rpvs

Our accounts dimension has 2 levels database name and account code. I Have a value prompt asking the user to choose a database name and a cross tab report with database name , account coce (in rows)  and  measures (in columns) . A filter for the query filters the report by database name choosen.

Question is how do i extract a set of account codes (account codes starting with '3')  from the list of accounts for the choosen database name. Functions like set are returning only for one database name but nothing when i change the database name.

Any help would be appreciated.

Thanks in advance!!!

MFGF

If I was writing the report, I would use the following approach:

Instead of bringing the Database Name level into the rows of your crosstab then adding a query filter, bring a Query Calculation into the rows, and code the expression as [your Database Name level] -> ?DbNameParam?
This will make the prompting for Database Name far more efficient than using a query filter.

For the Account codes, use a filter() function to filter on the attribute (caption?) that starts with 3

eg filter([your Account Codes level],[the attribute you want to filter on] starts with '3')

Regards,

MF.
Meep!