About hartmut_koerner

hartmut_koerner

"Integrated Financial Planning for SAP S/4HANA and S/4HANA Cloud" is the content package for SAP Analytics Cloud that covers the complete area of financial planning. The blog post Integrated Financial Planning - An Overview provides a single entry po...

hartmut_koerner

Introduction Integrated Financial Planning is a comprehensive content package for SAP Analytics Cloud that covers planning of operating expenses, of product costs, of sales and profitability, of CAPEX, and of financial statement. With the CAPEX modul...

hartmut_koerner

Introduction"Integrated Financial Planning for SAP S/4HANA and S/4HANA Cloud" is the content package for SAP Analytics Cloud that covers the complete area of financial planning. This package already exists several years now, it was enhanced step by s...

hartmut_koerner

Introduction Last year SAC introduced the new model type as successor of the classic account model. The new model brings together the measure based and the account based approach. When you create a new model there are two basic decisions that you nee...

hartmut_koerner

Introduction You can learn how to work with advanced formulas in different ways. You can study the syntax , understand the basic rules, learn from examples or simply use trial and error. Probably you will use all these approaches together. When I st...

hartmut_koerner

Hi Gavin,IFIACTPLNJEIC is the technical view name of CDS view I_ActualPlanJrnlEntryItemCube. Not sure how you consume this in SAC where the S/4HANA import connection is based on OData services. Probably you are using OData service API_JOURNALENTRYIT...

hartmut_koerner

Hi Thandeka,something like that:VARIABLEMEMBER #1 OF [d/Dimension1]// Calculate sum over other dimensions (here: Dimension1)DATA([d/Dimension1] = #1, [/dAccount] = "OD500") = RESULTLOOKUP([/dAccount] = "OD500") // Check if sum is positiveIF RESULTLOO...

hartmut_koerner

Hi Marija,yes, but the other dimensions that are mentioned in the error message are not restricted at all. If you don't need them, you should restrict them to # = Unassigned.Best regardsHartmut

hartmut_koerner

Hi Marija,the error message makes sense here because you create a huge amount of data. Comparison to null always is dangerous. For all member combinations that don't have data yet, the value of a measure is Null. I.e. your data action creates data fo...

hartmut_koerner

Hi, I got confirmation from the responsible developer that this is a bug. But there is a workaround: Use instead filter on GLAccountFlowType and IsBalanceSheetAccount.

User Statistics

User Activity

Integrated Financial Planning - Mathematical Foundation

Planning Investment Projects and Depreciations with Integrated Financial Planning for SAP Analytics Cloud

Integrated Financial Planning - An Overview

New Model - Configuration Options

Advanced Formulas – How they work

Re: Balance carryforward of actual data from SAP to SAC P...

Re: Data Action to swing account values

Re: SAC - Data Action Error - Too many member combinations

Re: SAC - Data Action Error - Too many member combinations

Re: SAC Import Model | Data Filter during Data Import