cancel
Showing results for 
Search instead for 
Did you mean: 

How many fact tables?

Former Member
0 Kudos

Hey Folks!

In our current project we design a star-based data model for our data warehouse.

We have a discussion about the fact table(s). The question is if we need one or two fact tables?

There are facts which represent amounts for a special dimension (week).

And there are facts which represent amounts over a time period (accumulate over many weeks).

Can we put these two types of amount together in one fact table?

Is there documentation available which describe design rules for fact tables?

Thanks for your help, and a nice weekend!

Stephan

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

The only way to have something "more", you have to collapse the requests

http://help.sap.com/saphelp_nw04/helpdata/en/ca/aa6437e7a4080ee10000009b38f842/content.htm

ot to create aggregates !

http://help.sap.com/saphelp_nw04/helpdata/en/7d/eb683cc5e8ca68e10000000a114084/frameset.htm

Hope it helps!

Bye,

Roberto

...and please don't forget to reward the answers...it's THE way to say thanks here !

Answers (2)

Answers (2)

former_member188975
Active Contributor
0 Kudos

Hi Stephan,

Have you seen this document...it may be useful for you:

http://help.sap.com/bp_biv133/documentation/Multi-dimensional_modeling_EN.doc

Hope this helps...

Former Member
0 Kudos

Hi Stephan,

As per the Extended star schema approch goes, you can have only single Fact Table surrounded by multiple dimension tables in your infocube.

Regards,

Amit