AS2K5. Linked Measure Group. Why schould I include all measures?

If I Link a measure group I can don't include all measures. The Visual Studo notify no error either during editing or during deploiment. But during processing I get fully unqulified error message such as following

Errors in the OLAP storage engine: The metadata for the statically linked measure group, with the name of 'Verkauf', cannot be verified against the source object.

What a behaviour? Is this by design?

This doesnt look like by design behavior. Sounds more like a defect in the product.
Please go ahead and file it using feedback site: http://connect.microsoft.com/SQLServer/feedback/

Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hi Edward.

The feedback site is a mess. There is not filtering by category (SSAS). I schoul use full text search.

AS 2005 cube browsing with an unprocessed measure group

Hi,

Is it possible to browse a AS 2005 cube in the Cube browser without having processed one of the measure groups.

These measure groups only share a few dimensions and are independent of each other.

Is there a way to browse the cube without having to delete the unprocessed measure group in the AS project/Mgmt studio? There is no real option to disable a measure group though.

Regards

Yes. You should be able to clear one of the measure groups in your cube and still be able to browse the cube.You can send ProcessClear command for that.

Another idea is to create a Perspective and select into it on the measures and dimensions you interested to show to your users.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

AS 2000, Excel 2003 and calulated measures

Hi

I have created a calculated measure - which when i view in the Analysis Manager - Browse it displays what I need.

In my Excel Pivot Table I cannot see the field when I Show Field List? is it possible to have calc members in Excel 2003?

however, my initial problem is this (and I am hoping someone can come up with a better solution):

I have a fact table that is simply number of hours worked per month and linked to dimensions such as the customer. Each Customer has a budgeted time (which is on the customer dimension) - I need to include this budget.

I have a separate cube that is the detail of the budget and I have tried creating a virtual cube - the problem with this is the budget is only visible if I use dimensions from that cube and the hours are only visible when I use dimensions from that cube - I would liek to see them together. (the dimensions in both cubes are identical)

Anyone?

Steve

Sounds like you have a bunch of private dimensions in your cubes. Its been a while since I worked on 2K, but i think global dimensions (dimensions that can be shared in virtual cubes) are called "shared dimensions". If you used the wizard to create the dimensions and cubes I think it defaults to adding dimensions as private.

|||

That may solve the virtual cube issue - thanks.

Any idea why I cannot see a calculated member in Excel while I can see it in the MMC browser?

Thanks

|||

Shared dimensions and virtual cubes work a treat - thanks.

Apparently, a calculated measure that is based on a dimension table does not appear in Excel 2003!!