sarandoniparthi on Thu, 31 Mar 2016 02:15:03
created a hierarchy like below
after processing the data some client no are missing
client no 4 is missing same under remaining client descriptions like canada,.. why the single value 4 is missing under all client descriptions.
yger on Thu, 31 Mar 2016 07:17:25
So your hierarchy would like
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?
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