image
yeeqinghew

3

Hierarchy in OLAP CUBE


Hi, anyone knows what hierarchy should I include in my credit card sign up fact table in OLAP CUBE?

For example,

Time Dimension: Year > Quarter > Month

Customer ??

Credit card ??

Campaign ??

thanks :))



- yeeqinghew
image

JayceEr

0

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 :))



- JayceEr
image

Kailiang96

1

Customer : AgeGroup > Income range > Customer ID Credit Card : Brand > Name Campaign: CpgnCode > CpgnDesc



- Kailiang96
image

JiaQii

2

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.



- JiaQii
image

Scottt

2

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.



- Scottt
image

ChinHin

0

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



- ChinHin
image

155952D

0

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.



- 155952D
image

OngChenYu

0

Depends on what you want to drill down to !



- OngChenYu
image

Bjergsen

4

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 .



- Bjergsen
image

IrfahIsham

0

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



- IrfahIsham
image

AlvinYap

0

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.



- AlvinYap
Cancel