Cognos Cube not allowed to update

Cognos Cube / mdc file not allowed to updated.

Problem: Window job fail to updated cube automatically and cube manual update fail.
Cause : Some body opened with .mdc file so that and playing with Power Play studio, so you can not update cube till that time .mdc file close - in network location.

Solution: Please close .mdc file and try to update cube after.

Thanks.

Cube not allowed generate Categories.

Cognos cube not allowed generated categories manually and Error in Transformer.

Problem : When tried generate categories manually, cube Cognos transformer not allowed.

Solution:

1. Find out which dimension cube not allowed generated categories manually
2. Right click on dimension
3. Properties of dimesion
4. General Tab
5. Check box click on "Prohibit automatic creation of new categories"
6. Click OK
7. Again generate categories manually
8. Done

report run multiple times with multiple prompts values

Requirement : One cognos report need to run multiple times with multiple prompts values, schedule.
Solution:

1. Prepared excel sheet with all values with respect prompt
2. Load into Event studio agent package (package should hold query iteam which keeps all report prompt values)
3. Create one agent in event studio using event studio packge
4. Configured report in newly created agent
5. Schedule that agnet to run date/time (hourly,daily,weekly)
6. Example :
1.  Agnet will run on every 1 hour.
2.  1st time agent and report will run on 8PM, then agnet will pass prompt values "India" to report
3.  2nd time agent and report will run on 9PM, then agnet will pass prompt values "China" to report
4.  3nd time agent and report will run on 10PM, then agnet will pass prompt values "Japan" to report

Excel sheet data

----------------

Country                  Time

=======               =====

India                       8 PM

China                      9 PM

Japan                      10 PM

UK                         11 PM

US                          12 PM

 

 

Thanks

  

Cognos Excel report tab Issue using & Sing

Hello,

Problem : I have faced issue "& " sign cognos excel report tab naming example 'Sales & Service'.
Solution : Just remove & sing just put and.
                 Example: Wrong : 'Sales & Service'
                                 Right : 'Sales and Service'

Thanks