Solved

what is fact table in your outline?

Posted on 2009-07-08
3
764 Views
Last Modified: 2012-05-07
what is fact table in your outline?& can i have more then one fact table in my outline?
0
Comment
Question by:AJITPADHY
  • 2
3 Comments
 
LVL 5

Accepted Solution

by:
garycris earned 500 total points
Comment Utility
Saying "fact table in my outline" would not be correct.

A fact table is something a little different.  Depending on if you are using a realtional database source and building your cube on a star schema, a fact table is the table that has all your data in it.

For Essbase purposes the fact table is often just a text file, that gets loaded into Essbase.

If you use Essbase Integration Services to build your cube from a realtional source then the fact table is in fact a table.  And yes EIS does allow you to use alternate fact tables during data loads.

0
 

Author Closing Comment

by:AJITPADHY
Comment Utility
thanks
0
 

Author Comment

by:AJITPADHY
Comment Utility
thanks
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now