Handling fact tables with different grain in Business Objects

Business Objects and joins across two (large) fact tables

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

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

Fact Table Grain at a Sub-Atomic Level

I'm thumbing through the Design Tips and would love to find some thought given to the statement made in The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling (pg 34): "Preferably you should develop dimensional models for the most

Fact dimensionality

I often run into the situation the we have several fact tables with different grains, but are related through a single ID at the transaction level. Typically the dimensionality is the same, but the related information doesn't exist in the source

Using a dimension in multiple fact tables with different grain and support SCD

Hello users, i've a question about using a dimension in fact tables with different granularity and at the same time retain support for SCD. My scenario: I have one Dimension called Apartment. This Dimension cosists of the following related

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

SET1/Q. 3 Explain the different types of reading that you have to engage in as a business executive.

Q. 3 Explain the different types of reading that you have to engage in as a business executive.

Amazing Race season 18-Unfinished business

Amazing Race 18 will be an all-star season and is now filming; teams identified The spring edition of The Amazing Race, which is in production right now, will be an all-star edition, in addition to being the first season to be filmed in

Fifth Business

Despite my last topic about a book going largely unnoticed, I will make yet another topic, this time about a novel. Novels are perhaps a little more interesting to discuss in an atmosphere like Lumine Hall than an encyclical would be. This topic will