Post reply

Data Warehouse Tables Design

  • November 24, 2008 at 7:54 pm

    #383452

    Hi,

    I have 2 Columns LineTotal and InvoiceTotal(LineTotal +tax+Shipping) .

    For example i have 2 item with $100 each so line total is $200

    and $25 tax and $25 shipping so Invoice Total of $200+$25+$25= $250

    if i drag both columns(Measures) my cube shows line total of $200 and Invoice total of $500 which is wrong

    How can i get correct result into my cube?

    is this possible to get using one fact table?

    Thanks

  • November 25, 2008 at 10:38 am

    #903304

    What does each record in the table represent?

    Is it 1 record per invoice, per order, per line item?

  • November 25, 2008 at 10:40 am

    #903306

    1 record per line item

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply