SQL Server Performance

Not able to create dimension members or Drop Dimension Members

Discussion in 'SQL Server 2005 Analysis Services' started by nallacnoo, Mar 19, 2008.

  1. nallacnoo New Member

    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.
  2. ranjitjain New Member

    Hi Srinivas,
    Dimension member can not be dropped unless dimension writeback is enabled and then the dimension has to be of parent-child relationship type. Can you elaborate more on this "Columns are coming dynamically", Even though the dimension members are changing, processing that dimension with ProcessUpdate option should refresh the data and all the members in that particular dimension.
  3. nallacnoo New Member

    Hi Ranjit,

    Thanks for your reply.
    I have enabled writeback to true on the dimension.

    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.


Share This Page