I am trying to rebuild our AS2000 cubes in AS2005. In AS2000 I have a
RateOfExchangeType dimension with two members, PIM & SQR, which
defaults to PIM (no ALL member), so that calculated measures which use
it are automatically using PIM unless the user selects SQR.
and I want it to default to PIM.
In AS2005 I have created a hierarchy within the dimension containing
those two members (the default attribute hierarchy has years as well so
that is hidden), set the default attribute member to PIM and the
IsAggregatable to False, but when I browse the cube PIM is not selected
by default and all my measures are blank (even the basic ones that come
directly from the fact table); when I select it they remain blank; when
I select the non-default member SQR both the standard and calculated
measures work correctly.
Does anyone have any idea why this would be happening?
Thank you

Hi, Rachel,
I have the same error with date dimension. I defined the default member as
last month, but all measures apears blank with default member. Its just for
information, I didn't found any solution yet.

Ramunas

"rachel" <rachel.jones (AT) talbotuw (DOT) com> wrote

Well it's nice to know I'm not the only one! It's driving me mad - it
seems such a simple thing and I cannot see why it doesn't work! Thanks
Ramunas.

Ramunas Balukonis wrote:

Do you have a simple repro-case?
I tried to build a simple model but it seems to work.
I you don't want post it on the forum, send it to me: marco.russo (at)
sqlbi.eu

Marco Russo
http://www.sqlbi.eu
http://www.sqljunkies.com/weblog/sqlbi

rachel wrote:

I had a similar problem when trying to set the default member in MDX
script. After a lot of trial and error, I determined that the MDX to
calculate the default member seems to fail the first time that it is
called, but will work when used a second time. As a workaround, I first
call the MDX in a hidden calculated member.

CREATE MEMBER CURRENTCUBE.[Data History].[Data History].[Bug
Workaround]
AS Tail([Data History].[Data Load].MEMBERS, 1).Item(0),
FORMAT_STRING = "#,#",
VISIBLE = 0 ;

ALTER CUBE CURRENTCUBE
UPDATE DIMENSION [Data History], DEFAULT_MEMBER = 'Tail([Data
History].[Data Load].MEMBERS, 1).Item(0)';


rachel wrote:

I have resolved this now with a redesign but I am not 100% sure why it
wouldn't work in the first place. In my DSV I had the dimension with
the ROEType joining to the fact table which held the rates on the type
and then another dimension containing the year joining to the fact
table on the year. I think the problem may have been to do with the
granularity attributes because it was a composite key on the ROEType
dimension table, consisting of the year and the type, but I was only
joining to the fact table on the type. It was definitely something in
the dimension usage that was causing the problem.
I have now built the dimension table directly from the fact table and
it all works properly.


Rachel

Graham Binner wrote: