Forum Discussion

JenJessel's avatar
JenJessel
New Contributor III
11 months ago

Percent Consolidation

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 kn...
Reports
JenJessel's avatar
JenJessel
New Contributor III

Thank you.  Will try this.

T_Kress's avatar
T_Kress
Contributor III
7 months ago

Also, if you vary this property by time or scenario:

Dim dValue As Decimal = BRApi.Finance.Entity.PercentConsolidation(si, entityId, parentId, varyByScenarioTypeId, varyByTimeId)
Dim percentage As Decimal = api.Entity.PercentConsolidation(entityId, parentId,varybyscenariptypeid,varybytimeid)
Dim entName As String = api.Members.GetMemberName(dimTypeId.Entity, entityId)
Dim parentName As String = api.Members.GetMemberName(dimTypeId.Entity, parentId)
						
api.LogMessage($"entName: {entName}; parentName: {parentName}; percentage = {percentage}")

 

Makes sure you set the last two options to true when pulling the %.

Then in your cube view if you have time across the columns and are varying this setting by time, it should show different % by time period.