Showing posts with label amo. Show all posts
Showing posts with label amo. Show all posts

Wednesday, March 7, 2012

Cube processing error: "The end of the input was reached"

I created a cube with AMO and examined it in BI Studio by importing. Everything looks fine, but I get the following error when processing the cube:

"Parser: The end of the input was reached".

The processing of dimensions appears to be successful. SSAS processes the cube immediately after finishing dimensions. That's where the error occurs. What is odd is that the process progress dialog box shows everything was completely successfully. I am quite sure that the processing of the cube was not completed because I cannot browse it and I know it takes much more than a duratio of 0 seconds to process the cube.

Could anyone offer some hint?

Thanks,

hz

It looks like the script you have for your cube contains syntax error. At least it should have "CALCULATE;" statement.
|||

I did not write the script. I wrote code in C# using AMO to create the cube. I do not know how to look at the script, but scripted the cube to a query editor window and did not see any CALCULATE statement. I also scripted a cube that is working perfectly and did not see CALCULATE in its script either.

At this point of time, I am temporarily giving up using AMO to create cubes and resorting to other means.

hz

Saturday, February 25, 2012

Cube Metadata - is AMO the best option

I want to extract the cube metadata I have into a relational repository. Should I be using AMO, or is there a simpler way?

Many thanks

AMO is an option. You could also use the XML definition of the cube directly and perhaps look into using SSIS's XML functionlity for persisting it to your database.