About pedrosan

pedrosan

Hi all, Do you know if it is possible to import data from Peoplesoft into a SAP Analytics Cloud Planning model? I checked the available connections and tought maybe the Odata or the JDBC might work but I want to be sure before moving forward. Any s...

pedrosan

Hi all, I am currently working with a customer that configured a file server location within SAC and the related connection. We are able to access the folder that was shared on the file server however we are wondering if there is a user friendly wa...

pedrosan

Hi all, We were wondering if it is possible to configure a live connection in SAC and then access the resulting artifact(view, model, table...) in order to use that "virtual" data and consume it in some stored procedures in HANA DB through Business...

pedrosan

Hi @raviakasapu ,Although I think it is awesome that you shared your javascript skills, it is always recommended to keep things simple and I believe the same outcome can be achieved without scripting(maybe even more dynamically by avoiding hardcoded ...

pedrosan

Hi @Anna_D Thank you for your answer! I ended up doing something similar, I copied the actuals to my plan version with a copy step and then performed the allocation via an advanced formula step.

pedrosan

Hi @jraymond15!Any chance to make this work without an account dimension in the model?I tried a similar approach using a calculated measure to generate a driver based on the previous year's actuals but the allocation did not work. I tested the same a...

pedrosan

Hi Orsolya,My understanding is that MS BC supports Odata therefore you could use SAC Data export service which is a PULL based open API. Please have a look at the links below:SAP Analytics Cloud REST APINew series exploring the SAP Analytics Cloud Da...

pedrosan

All right bittersweet news till then I guess 

User Statistics

User Activity

Importing HR data from Oracle Peoplesoft to SAC

How to upload files into the tomcat file server in order to import data into SAC Planning models

Using stored procedures to access/process SAC Planning data

Re: Creating a story with Dymanic Version & Date Combinations

Re: SAP Analytics Cloud Allocation: Part 4: Allocation using a Calculated Account

Re: SAP Analytics Cloud Allocation: Part 4: Allocation using a Calculated Account

Re: SAC planning to write back to ERP

Re: How to replace model in story in Optimized Design Experience?