Post reply

How to remove distinct clause from processing cube

  • July 11, 2011 at 4:26 am

    #253429

    hi...

    i'm newbie to the ssas ...

    my problem is i want to add the nvarchar field i.e wchar field

    in dimension when i process the dimension the error message is

    displayed duplicate values are there..

    so how to remove the distinct field from the processing query

    ..

    i want to display the duplicate values also...

    and please help me... to know how to process the dimension

    by table and also by attribute...

    help me...

  • July 11, 2011 at 5:48 am

    #1351010

    are you adding it as an attribute or a key?

  • July 11, 2011 at 5:55 am

    #1351017

    thanks for reply..

    i'm adding as Attribute..

  • July 11, 2011 at 6:04 am

    #1351022

    duplicate attribute members should not be a problem, I would check the attribute relations to see if the column is being used in a relationship and would need to be unqiue

  • July 11, 2011 at 6:20 am

    #1351038

    ok...

    please can u explain me how to processing group by table...

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply