Business Objects with Multiple Facts and Contexts

rjsmom1 at 04h49
18
Nov
2010
Business Objects with Multiple Facts and Contexts

We are finally using a dimensional model for reporting on a widespread basis. These universes have multiple fact tables. These fact tables have shared dimensions. Unfortunately, we have users now creating reports without pulling measures that would trigger which context to be used. In these cases, the user receive a prompt to select a context. Our users are having a really hard time with this, and I was wondering if anyone had exp
About
This topic belongs to the forum
  • Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.

  • Numbers of topics : 1858
  • Numbers of messages : 8714
  • Numbers of users : 3801
  • Numbers of points : 1672
Similar topics
In a business objects universe, I have several fact tables which are related by various dimensions. If I want to select facts from two of the fact tables, business objects will generate two separate queries, run the SQL and join the two results sets in th
One proposed model for our business (wholesale/retail) sales fact is to have every register ring in one fact. This causes refunds, voids, coupons and other 'facts' to be stored in a single fact entity. There is a column type dimension that then tells us
Hi I read Kimball's Data warehouse toolkit and I came across a point that one of the advantages of having star schema is - BI / reporting tools in the market can leverage the symmetrical nature of the star schema. From what I know and I could
Hi, i'm new to BI and Business Objects tools in particular. We have a fairly simple "Sales" datamodel - only 4 stars. the problem we're facing is the "SalesPlan" data. "SalesPlan" is defined on two different levels and more
Hi, I have a situation which I am trying to resolve but not able to Technologies Using : SQL Server and Analytics Services (SSAS) Background I have a flat file which is from the enterprise peoplesoft system and has the followings GL Account,
Forums from same category
See also
more_less
Informations

4 Replies For the topic :
"Business Objects with Multiple Facts and Contexts"

This topic has been viewed 2588 times.

Last message :
18/11/2010 at 04h49 by "rjsmom1"