SSAS Cube :: data not showing in browser tab .

  • HI All,

    We are facing very weired behavior in SSAS Olap Cube , We modified our named query and process the dimension and Cube but after that we are not able see any data in browser tab for any Cube .

    We have investigated below mention probable root cause :

    Calculate statement is mention in all the Cube.

    Partition is taking data during processing of the Cube.

    But still it's not showing data in Cube browsing tab .

    Please help us, if any one face this type of issue.

    Many Many Thanks,

    Alok

  • Explain in brief what problem are you facing.

  • Hi Thanks to reply,

    We made some modification in one view in data source view after that we process our dimension and Cube .We did not make any change except modification in dsv table.

    After that data is gone from the cube when we are checking in browser table , it's not showing any data for any Cube.

    Thanks,

    Alok

  • Maybe a stupid question:

    did you refresh/reconnect the browser?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Hi Thanks for reply,

    Yes , we have reconnected and refresh the Cube.

    Thanks,

    Alok

  • Can you browse the dimensions itself in their respective editors?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Thanks for reply,

    Yes we are able to browse dimensions.

    Thanks,

    Alok

  • This should be OK, since you could browse the cube before the modifications, but did you check the dimension usage tab to see if everything is connected correctly?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 8 posts - 1 through 7 (of 7 total)

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