Hi
I am trying to use BIDS Helper on an AS2005 cube to set the estimated counts for the cube partitions. I have 3 measure cubes that make up the 3 partitions. When i run the tool, it takes around an hour and then It throws around 40 errors, all of a similar nature:
"BIDS Helper Error setting estimated counts for dimension attributes of Group Current on partition FACT PORTFOLIO of measure group Portfolio: The 'AggregationDesignDimension' with 'Cube DimensionID' = 'GROUP PORTFOLIO SEGMENT 2' doesnt exist in the collection."
There is no dimension with that name or id 'GROUP PORTFOLIO SEGMENT 2' in the AS database. I have just noticed that if i open the cube in BIDS and in Cube Structure pain highlight the dimension in the bottom left, if i then look at the Properties pane, the ID under the Basic heading matches the 'Cube DimensionID' in the error message. However i cant see a way to edit this ID in BIDS.
Is this the reason for the error? if so how can i modify this property, as it does not seem to be editable.
Possibly related to this error, none of my partitions is now able to create any aggregations - could this be the same issue?
Your help would be much appreaciated.
Thanks
No files are attached