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

how to merge one query item to another query item in prompt

Started by inu, 07 Mar 2014 06:54:06 AM

Previous topic - Next topic

inu

HI
How to associate one query item to another in value prompt, for example i want year and quarter(2014-Q2) both merged in the value prompt.
Please u all are very helpful, helped me  a lot. Hope you would help me

Thanks
Inam

Lynn

I don't think you have enough detail to get the best advice. See point 1c here: http://www.cognoise.com/index.php/topic,24030.0.html

Relational or dimensional?
Is your question about how to construct the prompt query or how to compare prompt selections to filter your data?
What are the relevant data items available in your package and what data types are they? For example, do you have a date dimension and what are the components you have to work with?

Perhaps create a mock up of what you are trying to do that will better illustrate the requirement.