IBM Apptio

View Only

Export (Layout Only) with Multiple Local Currencies

Jump to Best Answer

Dawn Kassube posted Thu July 18, 2024 02:37 PM

Hello,

We are a global company and multiple currencies are entered by our Cost Center Owners. We then export Layout Only(Original Currency) to be imported by Hyperion at the Cost Center,Account,Entity,Currency level by Region. To get the Base Original Currency you cannot Group the columns resulting in the Export including many blank rows of data. I have tried creating a report in ApptioBI but you can only select the User Profile Currency or a Fixed Currency. We have the Currency field populated at the Base Cost Center Level but where Cost Centers for different currencies report to higher levels in the Hierarchy we cannot. How can we get rid of all these blank rows from the export?

Thank you,

#ApptioPlanning(ITP/ITFMF)

Ngoc Le posted Wed July 24, 2024 02:26 PM Best Answer

Many of our customers create an Export Table in CT to format data as needed, such as summarizing by cost center and account codes. Datalink or Published Tables can be configured to automate the data egress.

#ApptioPlanning(ITP/ITFMF)

Varad Rajeev Muthal posted Tue July 23, 2024 09:33 AM

Hello @Dawn Kassube, I acknowledge your query, and will get back to you with the answer.

Regards,
Varad

#ApptioPlanning(ITP/ITFMF)

Ngoc Le posted Tue July 23, 2024 10:05 AM

Hi @Dawn Kassube - can you remove the grouping and Export Layout? This will export all rows of data, including the Base currencies.

#ApptioPlanning(ITP/ITFMF)

Dawn Kassube posted Tue July 23, 2024 11:43 AM

Hello Ngoc,

I have removed the grouping and then I can get the original currency but my question was how to get rid of all the blank rows. Please see attached file. On a Forecast Plan, there is a separate line for each CC,Account,Entity,Currency and Month. We would like 1 line for CC/Account/Entity/Currency showing the Jan-Dec Months on the same line not different lines. In the attached file, the Worksheet Labeled Summarized Pivot is what we would like and the second Worksheet is what is currently Exported. Please note the csv file is the original download and the xlsx is with the Pivot.

#ApptioPlanning(ITP/ITFMF)

Attachments View in library

FY2024-6-Plus-6-Forecast_IT_Summary-Financia...csv 1.79 MB

FY2024-6-Plus-6-Forecast_IT_Summary-Financi...xlsx 1019 KB

Ngoc Le posted Wed July 24, 2024 01:56 PM

To align actual line items with forecast line items, you need to apply groupings to define the matching criteria. However, when rows are grouped, the child line items are converted into the default currency, causing the loss of the original currency in the export. The only way to retain the original currency is to export the individual line items and apply the groupings in Excel. I can't tell why there are so many blank rows in your export, though. Perhaps those are zero-value forecast line items?

#ApptioPlanning(ITP/ITFMF)

Dawn Kassube posted Wed July 24, 2024 02:13 PM

Hello,

Thank you for your response. I can get this to work in Cost Transparency as a report but wanted to try to use ApptioBI first. How do other companies export their Forecast and Budget data to Hyperion to get around this issue as our company requires the base currency? We also require 1 file to be uploaded into Hyperion for both Financial and Labor Count information by Entity, Cost Center, Account and Currency.

#ApptioPlanning(ITP/ITFMF)