Hi, I am working on my very first star schema based SSAS cube. I think it would be very simple for you, but I could use a lot of your help.
Here are the tables. Two dimension table. One fact.
In addition to the two dimensions, I will have region->country, year-qtr-week, BU-customerid as hierarchies. I know the fact table is not pure star schema, I will keep it as it is as a start with. so I will actually build the region->country,
year-qtr-week, BU-customerid hierachies off the fact table. The fact table is inherited. I want to leave as it is.
I will build two dimensions on the dim tables. what I need is to be able to take the count of week, amount of any region->country, year-qtr-week, BU-customerid , find the range in dim_dollarrange to get the description of the dollar range
, also find the range in dim_weekrange to get the frequency description.
How do I do the range look up in SSAS?
Can you please help ASAP? I would really appreciate it. this is my first sort of star schema prototyping. I will expand later to get into more depth of development. This is a start. Thanks for your help !
ID MinRange MaxRange Description
View Complete Post