Re: Attribute relatioships not working?

Thanks klm,

You very perfectly described the situation in tour reaction. I also use
the developer edition. To be exactly: Microsoft SQL Server 2005 -
9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c)
1988-2005 Microsoft Corporation Developer Edition on Windows NT 5.1
(Build 2600: Service Pack 2).
I also exprerimented with your idea's of using a "new" attribute
relationship in stead of the one already generated by the wizard in
earlier chapters. Something else I have tried is to phisically delete
the cube before deploying. Also changing from incremental to full
deployment did not solve the problem.
The longer I am struggling with this issue, th more I am comitted to
finding out why it won't work.

I created a new database with only the salesquota data and the time
dimension. My time dimension has both the fiscal and calendar
hierarchies, but I left out the levels below the fiscal quarter. If I
browse the cube via the calendar hierarchy everything is OK.
If I browse the cube by Fiscal Semester, I also see the correct data,
but I cannot view the data by fiscal quarter. Each fiscal quarter has
the value of the fiscal semester it belongs to. I am going to do some
further digging in this new database.
One interesting thing I have noticed is that if you reconnect in the
cube browser, the meta data pane is not (always) refreshed. I made som
significant changes in the time dimension. After reconnecting in the
cube browser, the data pane was refreshed, but the meta data remained
the same. Pressing F5 with the dimension or database object in the
metadata pane selected, actually refreshed the pane. One other thing
that crossed my mind is: could caching be part of the problem? I know
that data and meta data is cached on the server. I am going to do some
tests in that area as well.

I also have limited time to spend on this issue, but I keep you guys
posted with what I learn.

Marc

.

Relevant Pages

  • Re: Customize the joins between my Fact table and Dimensions?
    ... I have created a shared time dimension that goes down to the day ... In my Cube Editor, I want to join my fact table to my shared time ... Key in the Time dimension table, which links to a foreign key in the ... I'm currently using my live OLTP database as the source. ...
    (microsoft.public.sqlserver.olap)
  • Time dimension - YTD Error when used in cube
    ... When it's used as a dimension in a cube, ... Unable to display cell properties ... When the calculated member was created, the syntax was fine and no error ... for the column that the Time dimension 'links' to. ...
    (microsoft.public.sqlserver.olap)
  • Re: Last month in Time dimension (named sets?)
    ... Most solutions I see here are talking about using a measure in the MDX ... Added LastMonth bit filed to time dimension table ... cube build in DTS ... > periodicity dimension dn named sets as I see it. ...
    (microsoft.public.sqlserver.olap)
  • Re: Virtual cube
    ... > only time dimension and some kind of fact-table. ... > Remove time dimension from Sales Cube and sum up all cubes in an virtual ... > Greetings Monte ... >> Ramunas Balukonis ...
    (microsoft.public.sqlserver.olap)
  • Re: Cannot open a local cube created with AS2005 in Excel 2003
    ... Had to unregister the previous msolap90.dll version, ... both Excel 2007 and Excel 2003. ... If I try to create a new data source based on the local cube, ... If you used the download of Microsoft SQL Server 2005 Analysis ...
    (microsoft.public.sqlserver.olap)
Loading