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?