Problem: Define Custom member on local cube creation (Not measures dimension) 
Author Message
 Problem: Define Custom member on local cube creation (Not measures dimension)
I'm trying to make local cube with custom member which is not measures
dimension member.   Can you show me how to define custom member with mdx?

Thanks in advance.

Yong.



Mon, 26 Apr 2004 09:05:06 GMT
 Problem: Define Custom member on local cube creation (Not measures dimension)

Hi Yong,

If you mean a calculated member based on a Dimension that is not the
Measures' Dimension
then you could do something like so:

COMMAND (
        CREATE MEMBER CURRENTCUBE.Time.[My Time]
                AS '[Time].[1997].[2] - [Time].[1997].[4]' )

Regards

--
Walter Biffi
MS Analysis Services Consultant


Quote:
> I'm trying to make local cube with custom member which is not measures
> dimension member.   Can you show me how to define custom member with mdx?

> Thanks in advance.

> Yong.



Tue, 27 Apr 2004 00:29:58 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Custom members in Cube Dimension

2. Dimensions using custom member formulas in a virtual cube

3. Custom member properties in a local cube

4. Order cubes with measures not dimensions

5. Virtual Cube - measures from two member cubes results in outer join

6. Custom Member Formulas not working in Virtual Cube

7. Blank members appear in local cube created from virtual cube

8. Problem with parent child dimensions and local cubes

9. Problem with member properties in local cube

10. Problem in creating calculated member in local cubes using Pivot Table Services

11. Custom member formula vs. Calculated measure

12. Shared dimension processing: Dimension member key is not unique


 
Powered by phpBB® Forum Software