Highlighted
Contributor

How to get line item "Identifier"?

Hi anaplanners,

 

I have to set a summary to 'ratio' for 800 line items. I can automated this using excel then copy-paste.

 

The issue is that summary in excel looks like somewhat like this:

{"summaryMethod":"RATIO","timeSummaryMethod":"RATIO","timeSummarySameAsMainSummary":true,
"ratioNumeratorIdentifier":"_789000000401_","ratioDenominatorIdentifier":"_789000000389_"}.

I know that it's possible to get "hierarchyEntityLongId" using developer tools in Chrome. Maybe this can be solved same way?

 

It would really help me if I can somehow get this line item identifier. 

 

Thanks in advance,

Hayk

1 REPLY
Expert

Re: How to get line item "Identifier"?

Hi Hayk, this would require some programming or scripting to intergoate the JSON objects returned in the web response. So it's probably quicker to do manually on the line items tab in Anaplan. You can ctrl/cmd select multiple summary formats and paste in your desired settings.

I would question the need for 800 line items with ratio summary though, at least be careful there.
You might see a performance hit with that much aggregation depending on the dimesions and sizes of those 800 line items, and also what timescale they're using...