MS SQL Server OLAP - Excel Add-in doesn't recognise Named sets

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Excel Add-in doesn't recognise Named sets

AndyL

2006-03-31, 9:31 am

Hi, we're using the Excel add-in for Analysis Services to build reports on
top of some AS2000 cubes.

The add-in doesn't seem to be picking up Named Sets from the cubes (e.g.
'Rolling 12 months' on our time dimension) making it difficult to build
reports that will automatically update over time. It doesn't seem to have the
same problem with Calculated Members which is of some relief, but the named
sets thing is really bugging us.

Has anybody managed to get round this?

We thought about customising the MDX but that seems to be locked; does
anyody know if the object model allows you to get at this?

Any help would be much appreciated!!!

AndyL

Sponsored Links