If you are unable to create a new account, please email support@bspsoftware.com

 

When i pubilsh the data using table only layout, how can i identify

Started by Radhika, 20 Apr 2009 09:13:33 AM

Previous topic - Next topic

Radhika

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

jan.herout

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