what is conditional query subject and example
Answers were Sorted based on User's Feedback
Answer / amar
I hope There is no conditional query subject..
But we have query subject at Framework manager, Here we can
filter that query subject by using stand alone filters or
embed filters.
usage of query subject only for creating dimension need query
items for developing a report..
If any wrong let me know.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / rashmi
Main purpose of Conditional query subject is to have substitute data during run tme.
One way is to cretae Conditional query subjects uisng Paramet map. the value will be substituted during report run time.
| Is This Answer Correct ? | 0 Yes | 0 No |
-----------Diff b/W Aggregate Function and Rollup Aggrigate Function?
how to perform back drill through in cognos 8 what is the use of it
How to a create header dynamically in a crosstab report in cognos 8.1?
Can the expiration parameter of 365 in the cognos 8 configuration how to increase common symmetric key lifetime in days
What is a business view? and what is the difference b/w business view and folder?in cognos report life cycle when it will be involved ?
how do you test reports in reportnet? what do you record in unit testing documents? pls give answer in detail......
what are the filters in framework manager and report studio?
what are slowly changing dimensions? Why we are used scd?
4. How many dimensions did you use in your reports?
how to add a new query item by using 2 query subject? For Ex: i want to create a revenue query item in products query subject(revenue=Quantity*Unitprice). Quantity is in products query subject & unit price in orders query subject it will be possible in report studio(perment/temporerally) otherwise u have create in Freamework Manager... pls any body knows explain /answer me ?
How do you create IQD in FWM? Pls, give the procedure with an example. I told him that we could create using Native SQL method in FWM; it is correct or do you do another method there?
Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?