Hi, anyone knows what hierarchy should I include in my credit card sign up fact table in OLAP CUBE?
Time Dimension: Year > Quarter > Month
Credit card ??
Hi Yee Qing,
Customer: Age Group > Gender > Martial Status > Region > Customer ID
Credit Card: Brand > Name > Annual Fee > Credit Limit Range
Campaign: Year > Description
Hope it helps :))
Customer : AgeGroup > Income range > Customer ID Credit Card : Brand > Name Campaign: CpgnCode > CpgnDesc
The hierarchy should be in accordance to how you wanna break down your data. For example, if you wanna find number of signup per age group. Then your customer dimenison should include age group.
There isn't a fix way of ordering your hierarchy as it should be built in a way that you want to present your data.
Depending on how you want to break down your data and they way you want to present your data
EXAMPLE: Number of sign up > number of sign up for each car brand
There is no real correct way of having your hierarchy as it depends on how you want to analyse your data, therefore it depends on your business questions.
Depends on what you want to drill down to !
You have to see what is your business question before you can determine your hierarchy .Take some time to think through , there is no correct or wrong answer and it is based on individual analysis .
There is no right or wrong answer. The only thing is what you want to see , what you want to know . Hierachy choice is decided by what you want to analyze, drill in to. The main topic or focus of your question will be at the lower level of hierarchy you create
There is no right or wrong. It all depends on your business questions and how you want to present it. Have a kitkat, and then think about it thoroughly on how you want to present your data with the most optimum way.