The model should be reconsolidated

[Former Member]

Hi,

When I make ajustments to my PAS model I get the following warning: ".....the model should be reconsolidated".

How and where do I run this consolidation process?

Thanks,

Lars

[Former Member]

Hello,

Consolidate is run in Application server. ( PAS)

See the PAS help for Consolidate.

Here is an example of consolidation where Goods & Zone are dimensions and Actsales is a variable.

1.Specify a CHECKPOINT command that freezes the current status of the d

atabase:

CHECKPOINT FREEZE CONTINUE

2.Select the dimensions and variables you want to consolidate. For exam

ple:

SELECT Goods

SELECT Zone

SELECT Actsales

3.Specify the consolidation command for the period of time to be consol

idated. For example:

CONSOLIDATE Actsales PERIOD 1/1/99 - 12/1/00

4.Specify a CHECKPOINT command that updates the database:

CHECKPOINT UPDATE

5.Select other variables and continue consolidating. For example:

SELECT Goods

SELECT Zone

SELECT Budsales

CONSOLIDATE Budsales PERIOD 1/1/99 - 12/1/00

Note: The SET VARIABLE [CONSOLIDATE NOCONSOLIDATE] and CHECKPOINT comm

ands control the efficiency of a consolidation.

Thanks,

Bill

[Former Member]

Hi Miguel,

Thanks,

Lars

[Former Member]

Hi,

If you change the dimension (for example: add new output members) and you have data at the input level, then you may need to consolidate the variables to see the results in the new membersu2026

Where and How are you loading values?

Hope this helps,

Miguel

[Former Member]

Hi Miguel,

We are entering data via the Entry and Approval tool.

I am familiar with the need for reconsolidation, when a dimension has been modified, but just note sure which steps I need to run to consolidate.

Bw

Lars

[Former Member]

Hi,

If you use the entry and approval, I think that you only need to load the data again because all the measures (in consolinfo) will be consolidated...

Best Regards,

Miguel