I'm new to SSAS but I did some reading and some training already.
This is my third cube and I'm having trouble with my time dimension..
- first I browse the cube and drag the year and month to the columns section and it correctly renders only the times to which I have data
- then I drag my workstation dimention to the rows section and it's also shows the wks fine.
- Then I add my counter dimention to the rows section and it correctly shows up as a sub set of workstations.
- The problem: When I drop my value fact it renders different value to each counter but show the same value for ANY time, including future dates. (time dimension generated with SSAS)
Let me explain the cube, maybe you have seen something similar or could have some insight.
Fact: A hourly based table with counters for my workstations. Columns: Datetime, wksid, counterName, and value (value aggregated by max())
Dimention Workstation: id, name
Dimension Time: timeid, date, year, month, semester, etc.
Dimension counter: id, countername
All columns were connected to the correct related columns in the data source view. Why would the cube fail to correctly aggregate my facts by different dates? Any clue?
Please let me know if you need any clarification..
Thanks in advance!
View Complete Post