Hi,
I got the following error message while i was trying to do the aggregation wizard for SSAS 2005 cubes. I chose the storage setting as MOLAP then in the next screen , when i hit on the count objects, i am getting this error message.
'IBMDADB2.1' failed with no error message available, result code: DB_E_OBJECTOPEN(0x80040E05). (Microsoft Visual Studio)
Please let me know any one has got this error before and hot to fix it?
Thanks
Srinivas
Looks like the failrue is happening at the point where BI Dev studio is trying to count number of members in attributes in your dimensions.
At this point BI Dev studio will issue as query to relational database to get these counts.
You need to make sure you have permissions to access underlineed relational data from BI Dev studio.
As a workaround you can take a look at which attributes are missing counts and you change the EstimatedSize property of the attribute yourself.
If you provide the counts yourself you will be able to advance further in the aggregation design wizard.
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
No comments:
Post a Comment