Business Objects and joins across two (large) fact tables

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

Handling fact tables with different grain in Business Objects

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

DATE OR DATE KEYS IN FACT TABLES

I've read different opinions about the usage of dates in fact tables. If a date is NEVER used to filter and only reported, what is the purpose of adding it as a date key instead of a plain date type? Aren't we wasting the resources to get to the date

Multiple Fact Tables vs. Consolidated Fact Table

I am trying to put together the bus matrix (to identify the facts tables) for a government correctional agency and am debating between multiple facts for each event in the life cycle of an offender vs. fewer fact tables. I wanted to avoid joining multiple

Large number of snowflake code tables per dimension

Ten(10) or so key dimensions(lets call them base dimensions) each has about 25 parent code tables in the 3rd normal operational source. Each code has a short and long description. In the multidimensional model If a fact table has say 3 base dimensions the

Dimensional Model Vs Views as Structure for BOBJ Universe

I have a fairly complex data mart (multiple fact tables: 5 at the moment and several more coming; 4 shared dimensions across the 5 facts, 26 total dimensions and several bridge tables). I used standard best practices for building the Business Objects

Fact table with multiple date ?

Hi, I am modling a fact table for prisoners inscription in order to track historical changes. An admission is the hole stay comprise of one or many inscriptions usually separated by transferts between institutions. In the transactionnal system, it

Openings for SAP Trainee in Hages Business Solutions Pvt ltd

Industry: Computers / IT Education: B.Com / B.Sc / B.Tech/B.E. / BCA / MBA/PGDM Location: Ahmedabad Experience: 0 Years Job Details Fresher - Six months class room plus on the job training, Exposure of dealing with various clients across India

Combination of SCD2, partial snowflake, Effective and end dates in fact table

We are creating dataware housing for multitanant based systems for HR module. Requirement ?Able to report on historical data for any given data time. Active employees headcount till given date. (as of that day) Onhire and termination based on perticula

Accucore ERP system for VoIP business by Speedflow Communi

Accucore ERP system for VoIP business by Speedflow Communications It is important for VoIP company to have software solution which can be used for accounting and financial analysis. Accucore is over the billing system for VoIP companies, which meet

fact table as a dimension

Hi I'm presently modeling a data mart and I would like to use a fact table as a dimension for another fact table. Is it something doable and efficient or is there a better way to do that? if yes should i just create a surrogate key and link both

Announcements and Sticky topics in seperate tables!

Yep, according to the topic /other-problems-f46/possible-t76511.htm it isn't possible to split global announcements and stickies in a seperate table. I'm suggesting for this to be possible! I hate it when the forums are so messed up! I'm sure the

Regarding Factless Fact Tables

Some time ago I was asked to build the BI platform for a road safety organization. The warehouse was built of three primary fact tables, each with a collection of associated dimensions. I am now trying to branch out into ETL and Warehouse design, and from