|
INTERVIEW QUESTIONS
DATA WAREHOUSING
REPORTNET
DETAILS
Question: How do i allow a dynamic selection of a column for a measure in a chart,without using Variable
Answer: U can in do it in this way. first creat a list report in which u have a calculated item in the starting.
Then creat a prompt page with a value prompt.In value prompt creat static choice of which u want to be dynamically displayed.
Let the parameter of value prompt be ?Par1? and the choices as Revenue, Cost.
Now u write the expression of the calculated item in the report page as follows, "If ?Par1?=Revenue then Revenue else Cost.
Here Revenue,Cost should b dragged from the Model Items. So now the calculated item column displays the value of the one selected in the prompt.
Now make a graph using the list report,then place the calculated item on the axis of the chart ,which u wanted to display dynamically based on ur selection.
So now if u select Revenue in the prompt then the grph will take the values for Revenue.And if u select Cost then graph will be with the values of Cost.
Let me know wether this is working good r not,for my confirmation.
|
|
|
Category |
Reportnet Interview Questions & Answers -
Exam Mode /
Learning Mode
|
Rating |
(0.2) By 9258 users |
Added on |
7/27/2011 |
Views |
67524 |
Rate it! |
|
|
Question:
How do i allow a dynamic selection of a column for a measure in a chart,without using Variable
Answer:
U can in do it in this way. first creat a list report in which u have a calculated item in the starting.
Then creat a prompt page with a value prompt.In value prompt creat static choice of which u want to be dynamically displayed.
Let the parameter of value prompt be ?Par1? and the choices as Revenue, Cost.
Now u write the expression of the calculated item in the report page as follows, "If ?Par1?=Revenue then Revenue else Cost.
Here Revenue,Cost should b dragged from the Model Items. So now the calculated item column displays the value of the one selected in the prompt.
Now make a graph using the list report,then place the calculated item on the axis of the chart ,which u wanted to display dynamically based on ur selection.
So now if u select Revenue in the prompt then the grph will take the values for Revenue.And if u select Cost then graph will be with the values of Cost.
Let me know wether this is working good r not,for my confirmation.
Source: CoolInterview.com
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|
|
Related Questions |
View Answer |
|
How do we drill through from a powerplay cube to reportnet?
|
View Answer
|
|
What are versions of reportnet?
|
View Answer
|
|
What is prompt?types of prompts?use of prompts?syntax of prompt?
|
View Answer
|
|
What is difference between qurry studio and report studio?
|
View Answer
|
|
What are components of report studio?
|
View Answer
|
|
What are necessary tasks to install reportnet software
|
View Answer
|
|
What are components of reportnet?
|
View Answer
|
|
How do we provide security in frame work manager for a query subject?
|
View Answer
|
|
I want to display zero when null values coming to report how can I do that?
|
View Answer
|
|
How can i create prompts in report net
|
View Answer
|
|
Difference between filter and conditin
|
View Answer
|
|
Can report net connect multiple datasource at a time in report creation time
|
View Answer
|
|
How can i test report in reportnet
|
View Answer
|
|
What are the various file formats involved in reportnet?
|
View Answer
|
|
How to generate IQD file from framework manager
|
View Answer
|
|
Your client wants to ensure only specific users can create reports in Query Studio with other users creating reports using Report Studio. How can this be accomplished?
|
View Answer
|
|
What function should you use to display the value entered or selected by a user in response to a prompt?
|
View Answer
|
|
What are the advantages and disadvantages of reporting directly against the database?
Do you always need to copy the data before reporting on it?(example, real-time & on-demand reporting is a requirement)
|
View Answer
|
|
Report Studio allows you to create the data model from a query and thereby skipping Framework Manager. Given that this feature is available, in what scenarios would one want to skip Framework Manager? Is Framework Manager an un-needed overhead?
|
View Answer
|
|
What is difference b/w model&package?
|
View Answer
|