After processing the cube doesnt match the source data

  • Even stranger.

    I created another fact table with just a few facts and it works fine.

    SEN, SEN main Stream and As at January

    It doesnt work with all the facts in the one cube........

    I havent got a clue how to proceed from here. Im beginning to not trust Analysis Services and how it shows the data. Is this a bug?

  • I created another fact table with all the statemented facts in and it was fine.

    Is it the measure display folders ?

    I’m going to create another tester table with everything in here but the measures aren’t in any display folders. Yep its fine….

    Is it going wrong because of the Fact display folders?

    I had

    Statemented folder with SEN and SEN Mainstream in it

    I had a Statemented AS At display folder with the 12 months in

    I had a statemented Mainstream AS AT display folder with the 12 months in

    When I recreated without any measure display folders it works fine. So it looks like its something to do with the display folders.

    Huge sign of relief. This is something I can work with.

    Im going to do a bit of experimenting with display folders.

    I think this is VERY good news though 😀

Viewing 2 posts - 16 through 16 (of 16 total)

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