COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Cognos Administration => Topic started by: Eag. E on 09 Nov 2016 03:38:35 AM

Title: dimension can not display after cube changed (cache related)
Post by: Eag. E on 09 Nov 2016 03:38:35 AM
Hi

I have one question, it is based on 10.2.2 (Linux)
The test is as follow:
1. Cognos BI connect to abc.mdc as datasource
2. refresh and add a NEW dimension in abc.mdc
3. cp the new abc.mdc to replace the actual one
4. close browser/change another browser to do analysis, can see the new dimension not displayed

Wait for a little while, can see the new dimension.

Personally I believe this should caused by cache somewhere but I can not find how to clean this cache. I want to display the new dimension once abc.mdc changed.

Thanks for any of your suggestion
Title: Re: dimension can not display after cube changed (cache related)
Post by: misscognos on 01 Dec 2016 08:29:06 AM
I would do the following:

-create a brand new package on the same data source and see if the dimension is there.

-if it there Google how to recreate the run time models and recreate them.

- you mentioned you are copying the cube. Sounds like manual copying. I would suggest you look into the copy and activate strategy that is documented in the user guide if you are not already using it.
Title: Re: dimension can not display after cube changed (cache related)
Post by: bdbits on 02 Dec 2016 11:41:05 AM
Quote from: misscognos on 01 Dec 2016 08:29:06 AM
- you mentioned you are copying the cube. Sounds like manual copying. I would suggest you look into the copy and activate strategy that is documented in the user guide if you are not already using it.

This will likely resolve your issue as it makes Cognos immediately aware there is a refreshed cube. The 'activate' part will let queries in progress finish, and satisfy any new requests from the new cube.