Hi All,
Can anyone tell me when i pubilsh the data using table only layout, how can to identify facts and dimensions?
I read it forms Star Schema, but how to identify what are facts and dimensions?
Thanks in advance... :)
Radhika
Consider the following
- during publish, you have to choose which is the "dimension (read as dlist) for publish"
- items in this dlist will be translated into columns in resulting published cube
- most often, this dlist represents measures in fact table in the data mart you load published data into (however, not always).
- most often, this is the first dlist in your dcube (type 1)
Perhaps you can elaborate your question a bit?
Best regards, Jan
Thanks a lot, Jan. :)