February 2, 2012 at 10:29 am
Hi AGAIN 😀
I have a cube thats working really well. There are 3 parent child dimensions.
When Im using one of the attributes to filter on it shows duplicates. (In the Analysis Service bworser and reporting services)
For example Funding LEA
Derbyshire
Derbyshire
Derbyshire
Derbyshire
Derbyshire
<unknown>
<unknown>
<unknown>
<unknown>
<unknown>
Obviously this isnt what I want and I dont understand why its doing this? I would have thought even when using a parent child dimension at the lowest level you still only want one record in the filter for the query.
I really could use some advice on what Im doing wrong or what I can do to sort it out.
Debbie
February 2, 2012 at 10:42 am
*** usual its the key column. I had an attribute above funding LEA in the hierarchy which caused this to happen.
Its annoting because I wanted the data item above it but hey ho.
Does anyone know of any really good atricles about creating key columns and setting user defined hierarchies? I really struggle with this. It looks OK and they you realise you have created duplicates in the filter,
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply