Ok, so I reloaded the Adventure Works DW sample to get a clean slate.

I am starting to do work with time variance and used the wizard to generate
a "Date Calculations" hierarchy bound to the [Date].[Calendar] hierarchy.
By default, this hierarchy is not bound to existing perspectives. So I add
it to all perspectives under Adventure Works.

But when I browse the schema, the only Date Calculations member which shows
up on any of the perspectives is the "Current Date" member. On the Adventure
Works cube I see all of the calculated members. A bug? As a work-around,
should I always restrict on the base cube when asking what date calculation
members are present?

Chris Harrington
Active Interface, Inc.

http://www.activeinterface.com

how do you browse the schema?

"ChrisHarrington" <charrington-at-activeinterface.com> wrote

Jéjé,

Whether I list Date Calculation members with XMLA or browse with management
studio and select a perspective, the members list for perspectives only
shows the Current Date member:

If Channel Sales Perspective is the cube restriction, I get (showing
filtered results):


<root>
<row>
<MEMBER_NAME>Current Date</MEMBER_NAME>
<MEMBER_UNIQUE_NAME>[Date].[Calendar Date Calculations].&amp;[Current
Date]</MEMBER_UNIQUE_NAME>
<MEMBER_CAPTION>Current Date</MEMBER_CAPTION>
</row>
</root>


If Adventure Works is the cube restriction, I get:

<root>
<row>
<MEMBER_NAME>Current Date</MEMBER_NAME>
<MEMBER_UNIQUE_NAME>[Date].[Calendar Date Calculations].&amp;[Current
Date]</MEMBER_UNIQUE_NAME>
<MEMBER_CAPTION>Current Date</MEMBER_CAPTION>
</row>
<row>
<MEMBER_NAME>Year to Date</MEMBER_NAME>
<MEMBER_UNIQUE_NAME>[Date].[Calendar Date Calculations].[Year to
Date]</MEMBER_UNIQUE_NAME>
<MEMBER_CAPTION>Year to Date</MEMBER_CAPTION>
<EXPRESSION>true</EXPRESSION>
</row>
<row>
<MEMBER_NAME>Semester to Date</MEMBER_NAME>
<MEMBER_UNIQUE_NAME>[Date].[Calendar Date Calculations].[Semester to
Date]</MEMBER_UNIQUE_NAME>
<MEMBER_CAPTION>Semester to Date</MEMBER_CAPTION>
<EXPRESSION>true</EXPRESSION>
</row>

.... all others listed ...

</root>


"Jéjé" <willgart_A_ (AT) hotmail_A_ (DOT) com> wrote