Percent Consolidation

[JenJessel]

I am looking for a way to run a report for all time periods on percent consolidation.  Currently the only way I know how to do this is by running a grid view of for each month.  Does anyone know a more efficient solution?

[CarlosAlvear]

Hi Jen,

Maybe a dynamic calc member that recovers that information can do the work.

Regards 

[Henning]

I agree with Carlos, I would use a dynamic member. If you search for "percent" in snippets, you get this:

Dim dValue As Decimal = api.Entity.PercentConsolidation(entityId, parentId, varyByScenarioTypeId, varyByTimeId)

Please note that this only works with a specified parent, as every setting in the Relationship Properties tab in the entity dimension depends on the parent / can vary by parent.

[JenJessel]

Thank you.  Will try this.