SSAS Cube Metadata

[ukflix]

Hello
Has anyone used SSAS Cubes as a datasource for Cognos 10.2?  If so have you seen a situation where changes on the SSAS cube are not reflected in the package on Cognos.  For example, we incorrectly name a hierarchy "COSTOMER" and publish it.  A user opens up the package and browses the "COSTOMER" hierarchy.  Then that evening, we correct the "COSTOMER" hierarchy in SSAS and rebuild the cube.  Next day, the user still sees "COSTOMER" and not "CUSTOMER".  A new user opens up the SSAS cube and can see the correct name.  Seems like some sort of caching but I have cleared all of the caches I know about.  Tried restarting the service and server.  It follows the username too, ie if the first user logs onto Cognos from someoneelses machine, they still see "COSTOMER" in the metadata.  Any help appreciated.  Thanks

[bdbits]

One thing you could check - if you access SSAS directly (outside of Cognos), do your changes appear? That would at least tell you if the problem is on the SSAS or Cognos side.

Actually, I am going to be trying to expose an SSAS cube through Cognos this sometime in the next week or so.

[ukflix]

Hi

Yes the changes are reflected in SQL Server, Excel etc....

Even a new Cognos users who has not previously opened up the cube will see the changes.  It's like the cube metadata is cached when the cube is first accessed after a deployment, but the cache is not refreshing.  Only a full cube deployment seems to refresh it.  We are using DQM mode and apart from this we have had a really good experience with using SSAS cubes on Cognos.

Thanks for looking.

[bdbits]

Well, not sure where the caching problem lies, then. Maybe you will want to open a ticket with IBM Cognos and see what they have to say about it.