Question

sarandoniparthi on Thu, 31 Mar 2016 02:15:03


Hi,

created a hierarchy like below

client desc

client no

client name

after  processing  the data some client no are missing

US

  +1

   +2

    +5

     +6

 client no 4 is missing same under remaining client descriptions like canada,.. why the single value 4 is missing under all client descriptions.


Sponsored



Replies

yger on Thu, 31 Mar 2016 07:17:25


So your hierarchy would like

US

    1

    2

    4

CA

    4

    5

Which would mean that 4 can come under different Descriptions right? Did u create Composite KEys for 4?

sarandoniparthi on Thu, 31 Mar 2016 13:25:49


yes 4 can come under different descriptions,no i didn't create any composite key

yger on Thu, 31 Mar 2016 14:11:46


So u also got dublicate key Errors while processing the Dimension, right? Did u set the the error processing to ignore Errors or skip Errors?

Kr

sarandoniparthi on Thu, 31 Mar 2016 17:16:35


yes exactly placed ignore error or skip error ,i am waiting for the resolution pls give me an idea about this ssas cubes are new for me

Yvanlathem on Fri, 01 Apr 2016 07:40:04


Are your attribute relationships defined properly? Any screenshots to provide us?

yger on Fri, 01 Apr 2016 08:16:06


Create Composite keys where necessary: Go to the "Client No" Attribute in the Dimension -> Properties-> @Keycolumns add the "Client Desc" column to the key. Deploy and Process the Dimension. Do with NOT ignore or skip Errors. so u will get detailed Information if something goes wrong