Post reply

SSAS Molap Cube processing fine but no measure data in cube

  • February 27, 2017 at 2:57 am

    #327978

    I have a multidimensional SSAS cube, that all of a sudden doesn't work as intended.

    After processing, which runs successfully, there is no measure data, but there is data in dimensions in the cube. When i browse cube in SSMS-browser or Excel there are no fact rows returned.

    So my question is: How comes there is no measure data in my cube even though it processes fine?

    Information below

    Setup: I have four measure groups three of them with just one partition and one with four partitions (QueryBound) Dimensions and Facts are connected through surrogatekeys. Unknown members are set as "-1" during DWH load.

    I have tried the following:

    • Check there is data in Data Warehouse (there is)
    • Check that the queries SSAS are using returns data (they do)

    • Checked "Calculate" in my "Calculations" tab in SSAS and it is typed correctly. I even removed all logic. So it only says CALCULATE;

    • Also it seems that during processeing, rows are read from partitions.

    • I have also full loaded entire DWH, Cube, Database, Dimensions and all
    • Tried to explore data in data source view, which also gives data
    • Tried to remove all measure groups (delete them) in project and put them back but nothing works. All I get when browsing is this message: "No rows found. Click here to execute the query"
    • If i use Browser within the SSAS Project then there is still no fact data but also here I can see all members of the dimensions

    My own thoughts, but I don't know enough about the subject to test it:

    • Maybe it has something to do with impersonation settings?
    • Our SSAS project source code is currently located in GitHub which is accessed through Team Explorer in Visual Studio using GitHub login
    • We are pulling the newest version of project, do our developments and push it back to github and also deploying it to server. I haven't made any changes to the project it self from the point were it worked and to when it didn't. But sometime in between those points we moved our source code from on prem netowrk drive to GitHub
    • I'm developing and deploying both from my local machine and the test server it self. Both places i'm using my Windows credentials and they have to more or less everything (and it was also those credentials I have also used all the time)

  • February 27, 2017 at 9:18 am

    #1930492

    Unless you have implemented row-level security, I don't think it is an impersonation or permissions issue. I also don't think it has anything to do with your Git repository. 

    I would double-check the connection strings. You may be connecting to the correct source server in your Visual Studio project, but the connection property settings within the SSAS instance on the server could be different.

  • February 28, 2017 at 1:51 am

    #1930625

    Thanks for the reply, Martin.

    The solution was for me to delete one specific dimension, and adding it back to project - and then there were data. It wasn't a complex dimension at all, so I still don't know the exact reason why data was gone - but hey, now it works 🙂
    Hope it can help someone else anyways

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

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