Post reply

SSAS - calculate with measures from different fact tables

  • July 28, 2009 at 4:10 am

    #207379

    I designed a cube with 4 fact tables and some dimensions. It´s running fine. Now I´d like to add calculated fields.

    In my cube I have a stock measure table and a table for minimum/maximum stock.

    Now I´d like to calculate the difference between actual stock and minimum stock, but I always get the error message:

    Error1MdxScript(offenAuftraege) (7, 8) The Measures-Dimension contains several hierarchy. The hierarchy must be named.

  • July 28, 2009 at 4:37 am

    #1030940

    Have you checked the post below?

    http://www.sqlservercentral.com/Forums/Topic236419-147-1.aspx

  • July 28, 2009 at 5:39 am

    #1030963

    Yes, just aminute ago, but there´s no solution for my problem, I wrote Measures 🙂

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

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