How do you make a column drillable if its not a dimension hierarchy level?
What is refreshing of a cube and how can we do it
Refreshing the cube fetches the latest data to the cube. Which can be used to extract the latest reports out of it. Inorder to refresh the cube right click on the cube in powerplay transformer you will get an option refresh cube click on it and its done.
Refreshing the cube means it just gets the latest data and there is a option Refresh to do so.
Answer to Qn. 4.
Cleanhouse command removes all the categories generated during the cube build.
Drill down is like in time dimension from year to qtr to month to week etc., In drill through you cannot only drill down in a single dimension but you can go to the next dimension as well.EG take 3 di...
What is business intelligence?
Bi is an approach for gathering diff data sources on integrating into Big data sources on generating reports, simplifying decision making.
Decision making data
User Panel
Categories
Interview Coaching
Interview Question
Career Counselling
NH
Create a Alternate Drill down like if region is the name of dimension and the hierarchy is RegionCountry Branch NameBranch Name &...
Its better to use drillacross.