1.Create a calculated column which contains the information that the header is to contain, such as "Report for year 1999" (concatenated text and date to string sub string extraction). 2.Highlight
Latest Answer : You can use the following steps to have a dynamic column title1. Click the unlock button and unlock the report design2. Delete the column title3. Place a text item on the column4. Go to the query explorer5. Drag a data item into the query6. write the ...
How to show the data reported horizontally:(For example:)employee skill1 a1 b1 c2 d2 e2 fReport result:1 abc2 def
Assuming 3 records per grouped item:1. Group on employee2. Create a running count based on the skill field.3. Create 3 calculated columns based on the count field.Call them skill1, skill2, skill3:if (count
What is meant by Junk Dimension?How do you perfom while running the report?Where will you see the time of running report?Size of the cube?What are the types of prompts in ReportNet?What is macro and how it will be work?What is difference between Cognos and Cognos ReportNet?How do you create cube in ReportNet?There are 10 facts are there.How will you connect all?
I need answer
What is the difference between a cascading report and drillthru report?why do we go for drill thru report?
Latest Answer : group is used to eliniminate Duplicates,Where as Association is used to make one to one relation ship between to columns.ProctLine ProductName Quantity ...
Latest Answer : Slicing is a process in which you do an equality selection of data from one or more dimension(perspective of facts how it can be interpreted).In dicing, you obtain a dataset in a range of selection. ...
1.What are differences between Reporter report and Explorer report?2.What are purposes of Rollup?3.How to update the Cube invrementally?4.Purpose of Subsets?5.How to do the Manual Partitioning/6.Purpose of SubDimensions?7.Difference between drillup, drilldown and Drill through?8.How to create Cube groups?9.What is the work og PPES?10.What is Consolidation
1.What are differences between Reporter report and Explorer report?2.What are purposes of Rollup?3.How to update the Cube invrementally?4.Purpose of Subsets?5.How to do the Manual Partitioning/6.Purpose of SubDimensions?7.Difference between drillup, drilldown and Drill through?8.How to create Cube groups?9.What is the work og PPES?10.What is Consolidation?Please answer the questions. Even if u know the answers for very few questions,no problem. I need it urgently...Pls Friends.......
Latest Answer : macro is a dynamic object which is used to substiute the values at query run time.prompt is dynamic conditon which select the value or enter the value at query run time ...
1.diff between drill down and drill through?2. what is meant by roll-up?3.what is meant by external roll-up?how to create external rollup with example?4.what is meant by clean house command?5.what is meant by scope?what are types?explain them6.what is meant by cube groups?how to create cube groups?there is any simplest way to create cube groups?7.what is meant by alternate drill down with ex?8.how many cubes you are created till now?9.what is the size of the present cube?10.why you choose Ex-files