Link to home
Start Free TrialLog in
Avatar of unawillers
unawillers

asked on

SSAS Measure values not displaying in cube browser

Hi

Firstly I am new to developing udm cubes in SSAS so bear with me.

I have created a simple udm cube with 1 fact table, 1 time dimension, and a few regular dimensions.

In the Data Source View, I have developed a star schema with the fact table in the middle and relationships out to each of the dimensions with the fact as the source and the dimension as the target.

In the dimension browser, I can view the hierachies correctly also.

However when I deploy & process the cube, it runs through the process fine but when I goto browse the cube and pull in a dimension or measure its not displaying any values. I get the following (See file attached)

Now I did notice that in the processing (which I set to ProcessFull for now) that it is processing the fact before the dimensions? Should it not be the other way around?

Please advise
Lisa udm-cube.docx
SOLUTION
Avatar of ValentinoV
ValentinoV
Flag of Belgium image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of unawillers
unawillers

ASKER

Hi

Thx for reply, unfortunely it made no difference...:-( am at a brick wall here so any help/suggestions would be greatly appreciated
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
My issue was ultimately with the time dimension setup in the end. None of the answers provided alerted me to this. but they did prove helpful when working with ssas for the first time.