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
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.