Q
Problem solve Get help with specific problems with your technologies, process and projects.

Customized cubes: Benefits of partioning on time characteristics

Jay Narayanan provides expert advice on BW cubes partitioned on time characteristic and how the characteristic will aid data retrieval.

I have a problem with a customized cube. Usually the fact table of the cube will have merely the key figures and the dimension IDs. But, with this cube, the fact table has an entry:

"sid_0fiscper"

0fiscper is also maintained in the time dimension of the cube. How is it possible to have an entry other than the dim IDs, and key figures in the fact table of a cube? How is sid_0fiscper maintained in the fact table? Is there any purpose in designing the cube (fact table) like this?

The cube that you have created is partitioned on time characteristic 0fiscper. This is the reason why the characteristic sid_0fiscper has been added to the fact tables. This characteristic needs to be added to the e-table so that the table can be partitioned based on time, and the data retrieval will be faster due to partition pruning.
This was last published in March 2006

Dig Deeper on SAP business warehouse

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchManufacturingERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchCRM

SearchContentManagement

SearchFinancialApplications

Close