HOLD on cells to prevent breakback

[StuartS]

Hello

This post is asking confirmation.

Environment, Windows 2003, Cognos Analyst and Contributor. 8.1

My understanding is that in Analyst you can apply hold to cells which prevents breakback but that in contributor you cannot.  This is applying HOLD through a macro.

Is this right?

Thanks

Stuart

[ykud]

Yes, you're right.

There are tricks to work around it, but basically, there's no straight-forward hold macro in Contirbutor
But you can easily put individual holds on cells.

[StuartS]

Thank you for your fast response.

Damn :(

[ykud]

There are workarounds )
Describe your problem, maybe we'll figure smth out.

[StuartS]

I have a Cube with 2 dimensions, one which is Time Periods, and the other a dimension that allows a flag of actual or forecast.  In this cube the user enters the flag through a manager screen to a cube in analyst.

I can through use of another cube and a macro with @DcubeExport produce a txt file for import as an access table into the contributor model, therefore making cells READ or WRITE.  This other cube contains the Timescale and a dimension with two values, one that shows READ or WRITE depending on the flag in the first value.

My challenge is that the user would like to make use of the breakback functionality in Contributor.  In otherwords they would like to enter a number at Total Year and have it breakback over the months.  BUT, if a period is flagged as Actual, and actuals have been entered, then the user does not want to breakback over these cells.  READ access does not prevent this.

A challenge.  I do not see anyway of automating this in contributor.  At the moment my solution is to make the Total Year READ only.

Please say if I have not explained anything fully.. :)

[ykud]

Do you have access to Cognos Communities?
See this topic, the same idea can be adjusted in your case, I think.

Also, you can rewrite your year total to be conditional like:
'
IF Actual_Month = 11 THEN {December}
ELSE
IF Actual_Month = 10 THEN {November+December}
'
and the just set Actual Month flag in this dimension.

[StuartS]

Hello

I do not have access to the communities at my work PC.  Ill have a look from home.

I like your solution to do with the totals but, unfortunately the Full year would need to be the actual months, plus the forecast months.  This is unless I have not understood your solution.

Thanks


Stuart