Forum Discussion

Retha's avatar
Retha
Regular Visitor
8 years ago

objects missing with live connect to SSAS

I'm using live to connect to a multidimensional cube on SSAS, but not all my dimensions are visible. When I use import all of the missing one are available. Why is that, and what can I do to add the...
Retha's avatar
Retha
Regular Visitor
8 years ago

Had a look, but nothing there to explain why some dimensions (created the same way) are not pulling through with live

  • WolfBiber's avatar
    WolfBiber
    Microsoft Employee
    8 years ago

    Maybe a perspective or security Problem? 

    I have no trouble working with live connection and SSAS MD

    • Retha's avatar
      Retha
      Regular Visitor
      8 years ago

      Thanks for the response. I'm not sure as 99% of my dimensions and hierarchies does pull through it is just 2 of them that doesn't. If I use Excel, Proclarity and import they do pull through. 

      Unfortunately I cannot use import, as the amount of data is moer than 1 GB.

      Do you think it could be the size of the cube?