Create non-aggregation (Atomic) measure ?

Hi, All,

There are two dimensions and one measure group. In the measure group, I have only one measure which has no aggregation function on it. What I want to get is list all the measure detail based on the dimension attributes.

I have created this cube in SSAS 2005 successfully, but when I browsed it in browser,

I got error " The query could not be processed. Internal error: an unexpected error occured (file 'mdaggeng.cpp', line 515, function
'MDAggEngine::ComputerValueOrEvaluatot')"

Any idea on this?

Thanks

I'm not sure what is causing this error, but the primary value of SSAS is it's aggregations.

If you truely have one measure group, with one measure and don't want and aggregates done, then you would get better performance out of a SQL table.

|||

Thanks Darren for the advice.

The situation is that we have two cubes which are in different granularity but connected by "Conformed" Dimension. What required to do is to browse these cubes to retrieve the "atomic" (Non Aggregation) measures with the dimension attributes into a data set. And from the dataset, the reporting process will do the calculations. You are right, we can implement this directly against the SQL tables. But we are requested to show business users with "Cube-like" interface. I have created a cube to combine the two cubes in different granularity, but I have the difficult to bring up the measures. All the measures don't show up. In other words, the measures look like empty.

Do I miss something here?

'CREATE GLOBAL CUBE' issue

Hi,

I have cube with 10 measures and 20 dimensions. When I do 'CREATE GLOBAL CUBE',
using 10 measures with any 4 dimensions work fine, can create local cube, but could not success when I include 10 measures with any 6 or more dimensions.
The error msg: 'Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation.
Errors in the OLAP storage engine: An error occurred while processing the 'myCube' partition of the 'Fact myCube' measure group for the 'myCube' cube from the myCube database.
XML for Analysis parser: The XML for Analysis request timed out before it was completed.

Is it any limitations for 'CREATE GLOBAL CUBE'?

What am I missing?

Any suggestions or input will be appreciated.

Thanks.
We have identified many situations where local cube creation fails with this error. We have not found a way to work around these errors using CREATE GLOBAL CUBE. We have found ways to deal with these errors by using an ASSL Create Cube statement to create local cubes. Our product, CubeSlice, generates the required ASSL to create the local cube. We offer a free 30-day demo, so you can try it at no cost and see if your local cubes can be created with ASSL using all your dimensions. I'd encourage you to try the local cube creation with both a relational data source and an Analysis Server cube source. We give this option on the first tab of our Local Cube Options dialog. If you still get the error you describe when using CubeSlice, let me know, and we'll try to get it fixed.

Tim Peterson
www.cubeslice.com