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

Accepted answers

All comments

MarkWarren

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...

Hayk

Hi Mark,

thanks for caveat and your help. I've already managed to do that. It's possible to find those id's in a console, after you open summary setting and choose ratio.

I know that's not good to have 800 line items in one module, but that's the only way to meet the requirement in this case. Anyway the module's total size is a pretty small, so it works fine.

Thanks again

Quick Links

Can you help?

Unanswered questions

Cloud works on UX page
I am unable to see the cloudworks integration on the UX page. Can you advise what I am doing wrong
how to count how many times an action has run?
I want to create a line item which will increment by 1 every time an action is run manually. This action is an import which doesn't involve any file upload to anaplan. The module where I want this line item has users list & SKU list dimension. No time. So basically, I want to track how many users have selected an SKU and…
Missing Column Headers in Anaplan Export When Using API
Hi Community, I’m encountering an issue where an export created in Anaplan is missing column headers when retrieved via the API. However, when I manually run the same export from the Actions tab, the downloaded file includes the headers. Has anyone experienced this behavior before? I’d appreciate any insights into the root…