Error creating UBO in SSAS via BIDS Helper

Topics: Standing Discussions
Jul 1, 2013 at 7:47 AM
Hi guys,

I'm getting the an error when atttempting to create usage based aggregations via BIDS helper.

Basically, I'm going to Partitions --> Edit Aggregations (BIDS Helper --> Right-click --> Add from query log...
Then I change the connection string and query to point to our production environment as a source for log information. Everything seems fine until I click OK, when I get the following error:

"Error saving aggregation #282: The key property (used as index in collection) is not defined."

Anyone have any ideas as to what this means?

Thanks
Coordinator
Jul 1, 2013 at 6:31 PM
I suspect that the list of dimensions or the list of dimension attributes doesn't match in production vs your source code. It's trying to parse the string of 0's and 1's and failing.

I would suggest you reverse engineer your production solution, generate aggs, run printer friendly aggs, then manually create those aggs in your dev source code. Not fun. I know. That's why you design aggs on matching deployed solutions.