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
Henning's avatar
Henning
Valued Contributor II
11 months ago

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.

 

  • YReddy's avatar
    YReddy
    New Contributor
    7 months ago

    Hi Heing, 

    I have encountered an issue while trying to implement a solution in the Cube View. Regardless of the percentage assigned to the entity, the Cube View is displaying a constant value of 100.00.

    I have double-checked the configuration and the data input, but the issue persists. Could you please provide guidance or suggest any troubleshooting steps to resolve this?


    • FredLucas's avatar
      FredLucas
      Contributor III
      7 months ago

      Hi YReddy,

      The first thing I would do to troubleshoot it would be to write the entity and parent to the error log to see if you can spot any issues with the parameters being used by the PercentConsolidation function. You could try something like this:

      Dim percentage As Decimal = api.Entity.PercentConsolidation(entityId, parentId)
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}")