What is slicer & dicer ? what is sub session parameter ?
Answer Posted / saisudheer v
Slicers – Slicing is a process which could be used to eliminate the data which is not necessary for current analysis. for example if we are interested in analysis of the sales of a product during the first quater of the year then we can drill down the time dimension to resolution 2 level and then slice the cube for the first three months leading to the slicing process
If the above process is carried out in certical direction we call it dicing
for clear understanding refer: http://www.performanceg2.com/creating-slicers-in-report-studio/
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can you define pivot?
After applying date prompt and when we run the report we
fet from date and todate prompts..so when we enter
todate how to create measures and dimensions? What are the types of hierarchies? Please Answer this Questions:
1.In FWM We have to create Hierarchies, Condition is we
don't know the correct levels in the Hierarchies, in this
case how can we find out the levels
(year->Quarters->month->day)in data?
2. In FWM Standalone Filter is for Reusable purpose &
Embedded Filter we cant resuse.but is this possible to
convert the Embedded filter to standalone filter?
3.What are the differences between Relational Database Model
& Multi Dimensional Database?
4.In Drill Down/ Drill Up, How to specify the limits for
example in a report there is 6 Drill down is possible, but i
want only 3 Drill downs, the report should not allow 4 Th
Drill Down.How to make this ?
4. What are the limitations in Select and Search Prompt ?
What r the names of the reports that you prepared? What are the services provided in cognos 8? How can we Maintain the Cube Security by Category level and
Dimension level ? write a query to display the departments with no employee? Can we create 2 conditions in report expression of a single
data item..Eg: I added 2 new dataitems each one should
show revenue for Q1 and Q2..Pls advice what is power prompt in cognos ep7series?what is the use of
this? What is difference between page break and section report? What is main advantage datawarehousing over oracle? please please give me some banking calculations in
framework manager. What is meant by drill down? is cognos 7 is better than cognos 8