Thursday, September 06, 2012 6:53 PM
I have a Fact table with 100m rows. I'm trying to create a drillthrough solution to abstract Fullname, address and phone number from the same underlying Fact table for corresponding selected cell.
1. Created a Fact Dimension for the given attributes(3) plus Fact table PK.
2. Set up Dimension Usage relation type as Fact
3. Left the default storageMode of the Fact Dimension as MOLAP and processed the cube.
The processing didn't complete even after 16 hrs, So I stopped it and changed the Storage mode to ROLAP, which processed fine.
Now, I could see the FactDimension on Cube browser. After this, I created a new drill through action and specified the 3
Attributes from the FactDimension and deployed the changes.
Now, when I go back to the cube browser, and I right click the a cell, and click on the drillthrough action, I get the following error:
" The selected action cannot be completed because of the following error. Server: the operation has been cancelled.
OLE DB error: OLE DB or ODBC error: Invalid column name 'FullName', Invalid column name'address', invalid column name 'Phonenumber'.
This error may have occurred because the definition for the action is not valid. Verify the defininition using actions view."
On top of that, If i write any drill through queries, with drillthrough statement in a query window, it throws the same error
Executing the query ...
Server: The operation has been cancelled.
OLE DB error: OLE DB or ODBC error: Invalid column name 'FullName'.; 42S22; Invalid column name 'Phonenumber'.; 42S22; Invalid column name 'FId'.; 42S22.
Can somebody Help?
- Edited by GedaGudi Thursday, September 06, 2012 7:50 PM