If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Adding a new Dimension

Started by chewza, 08 May 2016 12:29:57 AM

Previous topic - Next topic

chewza

Hi there

I have added a new dimension to my transformer model, and none of our existing reports work against the new cube.
Is there any way around this? I can understand that deleting a dimension would cause issues, but was hoping that adding a new one would not cause issues......

Many thanks!!!


Regards
Chris

Lynn

Quote from: chewza on 08 May 2016 12:29:57 AM
Hi there

I have added a new dimension to my transformer model, and none of our existing reports work against the new cube.
Is there any way around this? I can understand that deleting a dimension would cause issues, but was hoping that adding a new one would not cause issues......

Many thanks!!!


Regards
Chris

Was it Miss Scarlet in the drawing room with a candlestick?

Difficult to offer suggestions without any detail beyond the fact that reports don't work. Why not share any error messages, if any. Or perhaps share examples that illustrate incorrect results vs. previously correct results. Any clue at all would be welcome.

If I had to make a totally wild guess I'd suggest that perhaps the MUNs in existing dimensions have perhaps changed. If you have MUNs with ~ characters these are generated to resolve uniqueness issues and can vary as things change, causing reports to break. The link below explains how to model so as to avoid this situation, making your cube more durable.

https://www.ibm.com/support/knowledgecenter/SSEP7J_10.2.1/com.ibm.swg.ba.cognos.ug_cogtr.10.2.1.doc/c_bp_uniqueness.html%23bp_uniqueness

Again, this is a total guess because you haven't given very much information so difficult to offer much beyond solutions to common problems.

Ricardo Julio "Ricky" Villa

Yeah, I doubt it has anything to do with the new dimension added.

Something else has changed... Data changes resulting in missing MUN's (i.e. categories in your dimensions) or existing MUN's being changed is a good place to start looking...