October 14, 2008 at 11:17 am
I have a cube which I would like to start developing reports for. I have a question about factless fact tables and dimensions.
In my data warehouse, I have a GL fact table which holds some non-measurable information. I don't necessarily need this extra info. to become dimensions for creating hierarchies and filter with, etc. I would just like this extra info to be displayed in my reports for informational purposes only!
Should I create one factless fact table and dump all the extra info into the table and join the fact table GL by primary key? Or should I create seperate dimensions for each? I'm just curious what some of you all have done in this situation.
Remember, I want to pull this data from the cube not data warehouse.
Thanks!
October 14, 2008 at 11:30 am
If you want to get it from the cube, you will need to create at least member properties for the information - so you need it to end up in dimensions. If you do not want to slice on the information, you do not need to make them attribute hierarchies.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply