Hi,
I do not understand why a formula in my query is not executed in HANA DB. We are on BW750/25 on HANA. I use this formula:
IF("[ZPLPRODTM] Planned Production Time" > "[0ACTEXECTMX] Production time (1000; Sensor T+Z; PP01)"; "[0ACTEXECTMX] Prod...
Hi,
we use a generic DataSource based directly on table PROJ. Using S-API with InfoPackage we receive ~10.000 records in BW, using ODP with DTP (no PSA) we recive ~300 records.
In both ways we use a full load.
Any ideas, why ODP does not send s...
Hi,
we use AFO for Planning (BI-IP) and for new lines we use characteristic relationship for F4 help.
Everything works fine, when we use F4 Help for material only valid values based on characteristic relationship are shown. When we search in Resu...
Hi,
we use an AFO Workbook for planning (BI-IP) and enter new combinations (new lines). Only in new lines the first key figure (see screenshot) is not input able as it has the wrong data cell format ("SAPReadOnlyDataCell" instead of "SAPEditableDat...
Hi,
we extract data using 0FI_GL_4 and during delta load we face an interesting situation.
a document is twice in ODQMON, same ODQ_TSN number but different ODQ_UNITNO ( 1 and 2 ). As there is no difference in any field of the document, why is the...
Hi,after a few more hours of research I have a solution. First of all "IF" is not supported, so we had to go back to the old version with "< * =". Second reason was that key figures have units. When we use KeyFigures without units, the formula works ...
Hi,figured out that the problem was declaration of data source as text data source. Using datasource as attribute datasource extracts all data. BRGunter
Hello Martin,thank you for your message, in the end we had to open a SAP ticket. It was an AFO problem:"In AFO 2.8 SP8 or higher version, make sure the setting UseSingleConnectionPerDestination is checked (TRUE)."https://launchpad.support.sap.com/#/n...
Hi, sorry, here is the macro:******************************Sub ART_GRP_SAVE()Dim lResult As LongDim lResult1 As VariantlResult =
Application.Run("SAPSetRefreshBehaviour", "Off")'1. Save datalResult =
Application.Run("SAPExecuteCommand", "PlanDataSave...