Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
My Sales Cube shows same Name for different CustomerCategory Codes

Unanswered My Sales Cube shows same Name for different CustomerCategory Codes

  • Saturday, March 02, 2013 8:15 AM
     
     
    Sign In to Vote
    0

    Hello,

    I have a problem in cube, it shows the same CustomerCatgoryName for different CustomerCategoryCodes. The Customer Dimension table has correct data, with different codes having different names, but not sure why the cube shows same name across all.

    Can you please help me to find the root cause for this, seems something related to underlying data, but not sure what can make the cube behave this way.

    Vinish Viswanathan

     

All Replies

  • Sunday, March 03, 2013 4:57 AM
     
     
    Sign In to Vote
    0

    Do let me know if any more details are required.

    Vinish Viswanathan

     
  • Monday, March 04, 2013 6:32 AM
    Moderator
     
     
    Sign In to Vote
    0

    Hi Vinish,

    What do you mean that "the same CustomerCatgoryName for different CustomerCategoryCodes"? If possible, please post some code to elaborate your issue with more detail.

    Regards,

    Elvis Long
    TechNet Community Support

     
  • Monday, March 04, 2013 11:03 AM
     
     
    Sign In to Vote
    0

    hi,

    we have options like the value column and the name column in the dimension properties try to use them in order to solve your problem.

    please let me know still your facing the issue

    thanks

    D.Nagarjuna

     
  • Monday, March 04, 2013 12:36 PM
     
     
    Sign In to Vote
    0

    Hello Vinish,

    I would recommend you to check the namecolumn property, as that decides what is being displayed to the end user?

    Also, the key column property determines its uniqueness..Did you get any processing errors like duplicate entries, when you process the cube?

    Thanks,

    Muthu

     
  • Tuesday, March 05, 2013 5:36 AM
     
     
    Sign In to Vote
    0

    Hello All,

    Just to give some more details:

    1. I don't get any error while cube processing.

    2. Example:

    Data in the customer dimension table:

    CustomerCategoryCode: 1234

    CustomerCategoryName: ABCD

    CustomerCategoryCode: 5678

    CustomerCategoryName: XYZ

    Data shown in the cubes:

    CustomerCategoryCode: 1234

    CustomerCategoryName: ABCD

    CustomerCategoryCode: 5678

    CustomerCategoryName: ABCD

    So in cube i see same name for different codes, even though in db i have the correct values. 

    3. There exists a Natural Hierarchy between the below filed and we have an attribute relationship defined ( below example is for Codes, same exists for Names).

    Top to Bottom Hierarchy:

    CustomerChannelCode

    CustomerCategoryCode

    CustomerOutletCode

    CustomerCode

    I have few cases where same CustomerCode has multiple OutletCodes, not sure if this can create issues. As in another db its the same but all works fine there.

    Hope this gives much insight into the issue. Any quick help would be much appreciated, with a possible work around ( if changing the design is the only solution).

    Vinish Viswanathan

     
  • Thursday, March 07, 2013 10:04 AM
     
     
    Sign In to Vote
    0

    Hi Vinish ,

    Could it be you're dealing with Many-To-Many issue between the hierarchy levels ?

    I hope the next links will give you an idea  :)

    http://stackoverflow.com/questions/11090005/ssas-many-to-many-column-hierarchy

    http://dbaspot.com/sqlserver-olap/164293-many-many-relation-between-dimension-leveles.html

    Regards, David .

     
  • Thursday, March 07, 2013 2:23 PM
     
     
    Sign In to Vote
    0
    In your DSV, are you referencing the dimension table directly, or a database view?  If it's a database view, I'd suggest looking there to see what data is actually being returned from the query.