I'm using SAC add-in for Microsoft Excel.Is there a way to have SAC add-in for Microsoft Excel automatically sign-in and refresh the tables when opening the Excel file?Thanks,Regards,Mel Calucin
In BW, we create calculation views in the BW HANA database and consume them in compositeproviders and datasources. Building and troubleshooting data models as calculation views is a lot easier doing the same type of modeling in compositeproviders.
...
Per the following AFO screenshot:
I'm trying to get the value of "Actual Amount GC USD" for 0GL_ACCOUNT hierarchy node HFSV11 using the SAPGetData function, but I'm having issue with the syntax for +NodeKey(NodeTypeName) parameter.
Below is w...
Hello,
Is there any information (like an ERM diagram) on how these Transportation Management tables link together?
/SCMTMS/D_SF_ITM/SCMTMS/D_SF_ROTSCMTMS/D_TOREXESCMTMS/D_TCDROT
/SCMTMS/D_TCHRGR/SCMTMS/D_TORSSU/SCMTMS/D_TORSTS/SCMTMS/D_TCDITM/S...
Using the Datasphere connection with "SAP BW" connecting to a BW/4HANA 2.0 system, I created a remote table to a CompositeProvider. I loaded a snapshot of the data, but when I went to Data Viewer, it came up with "No data".
I can see from Eclipse ...
If you have S/4, you can create a CDS view using the tables usrbf2 and ust12 to get a list of users who have access on S/4 for certain cost centers. You can then use this CDS view in Datasphere for your DAC. Regards,Mel Calucin
Hi Stefan,Thanks for the very informative blog. Using this blog, I manage to get my BW/4HANA system working with Snowflake via SDI - DP Agent. It's been working ever since I read this blog almost two years ago.However, something new has come up. ...
Hi Nikhil,Thanks for the suggested fix.I have SSO on the SAC tenant. Hence, I do not have to login to SAC. However, I still have to sign in when opening the Excel file that is connected to the SAC tenant. Only then will the table be refreshed.Re...
HI Xavier,Thanks for the reply. Interesting about the hierarchy management being done in HANA DB. Is there a tool in HANA DB that is similar tcode RSH1 in BW to manage hierarchies? I know something like RSH1 doesn't exist in Datasphere.Thanks!Reg...
