Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Create or Drop Dimension Members Expand / Collapse
Author
Message
Posted Wednesday, March 19, 2008 4:04 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, December 3, 2009 10:23 PM
Points: 2, Visits: 30
Hi All,

I am Srinivas working on SSAS 2005. I am not able to create or drop dimension members. I need to drop and create all members in one dimension before cube processing, as the columns are coming dynamically.

E.g. ALTER CUBE [Reporting] DROP DIMENSION MEMBER [Tbl Analysis Test].[Name]
Here cube is [Reporting] , dimension is [Tbl Analysis Test] and member is [Name].

Its giving the following error " Parsing the query ... Query (1, 46) The member '[Name]' was not found in the cube when the string, [Tbl Analysis Test].[Name], was parsed. Parsing complete"

Please look into this issue, advice me what do I do ASAP.

Thanks,
Srinivas
Post #471465
Posted Thursday, March 20, 2008 9:42 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, March 27, 2014 1:47 PM
Points: 215, Visits: 415
It looks like you're referencing just the Atttribute as opposed to the member. I'd expect a reference something like:

[Tbl Analysis Test].[Name].&[some key value]

This statement is to drop out individual members, for example if you want to process them, but don't want them available before use.

Based on you post, instead try unprocessing the dimension, then processing the dimension and then the cube.
Post #472353
Posted Friday, March 21, 2008 12:12 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, December 3, 2009 10:23 PM
Points: 2, Visits: 30
Thanks for your reply.

Let me explain my requirement background.

1) We have a User Dimension which has UserID as member under this member it will have some member properties which can't be pre-determined.
2) So I re-create the User Dimension Table in SSIS Process and here I have to drop all the existing MEMBER PROPERTIES and then re-create it.

Example Data
==========
UserID SecGroup1 SecGroup2 SecGroup3 ...............SecGroupN
100 Yes No Yes

Here SecGroup can not be determined. So we re-create the table structure and populate the data through SSIS.

In the same SSIS we would like to re-create the MEMBER PROPERTIES using MDX Definition Statments.

Doing this we enable Dimension Write-back Option for the User Dimension.

Hope you will get my requirement.

Thanks,
Srinivas
Post #472686
Posted Saturday, March 22, 2008 7:00 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, March 27, 2014 1:47 PM
Points: 215, Visits: 415
Ok, I believe you're looking in the wrong area. MDX statements are for cubes, where the basic cube structure is known and fixed.

You're into ASSL development, which is going to require some intensive work. As well, as you alter the cube in te manner you're describing, you need to think about rebuilding your aggregations, checking / validating any scripts, etc.

I'd suggest reexamining the problem. Have you considered inverting the relationship so that you have userID, SecGroupID, and Value (Yes/No)?
Post #473202
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse