PBCS - Smart Push Option

 To load data form one cube to another cube, we were using calc scripts to copy data from one cube to another, either to BSO to BSO or mainly BSO to ASO.

Now we have one smart feature with new versions and with cloud applications like EPM Cloud Planning.

That is Smart Push.

We can push data from one cube to another cube i.e either BSO to BSO or BSO to ASO, we can select Smart Push option in the data forms itself.

We can select this option in Simple Data form or Composite Data form also.

https://docs.oracle.com/cd/E57185_01/AGOHP/ch10s03s09s02.html

Thanks,

Madhusudhan

OneStream Admin Screen

 OneStream System Administration will be handled by below, which Admin only can access.

All Security, Application Creation, Database Creation, Logging activities, Logs, Environment details, We can check and monitor server is Server Status, then we can create users, create security groups, assign security groups, Load Application artifacts, Extract Artifacts etc.

Thanks,

Madhusudhan

OneStream Basics1

 Some basics you can find here, which we will update regularly.

In OneStream, We can access URL in 3 types.

• Desktop Version with help of Client
• Web URL - Heard that Web URL going to discontinue in few days, as silver light support needed for the same
• Excel like SmartView in Hyperion

In OneStream, We can download client software from MARKETPLACE. Once you login, you can OneStream Reference guide (Like Admin guide in Hyperion)

In OneStream, Totally 18 Dimensions will be there, including Custom Dimensions.

• System Defined Dimensions    - Parent, Consolidation, Time, View, Origin, IC
• User Defined Dimensions        - Entity, Scenario, Account, Flow, All User Defined Dimensions 8

In OneStream, System Defined Dimensions will create default whenever we create User Defined Dimensions. For Example:

• Parent Dimension will create by creating Entity. 
• Consolidation dimension will create by creating Currency. 
• Once we define Start and End Year in Application Properties, Time dimension will get create by the system Years along with Months
• View Dimension will create by system along with Periodic members QTD, YTD etc. This dimension will expect anything like above dimensions, view dimension completely create by system.
• Origin Dimension also as View Dimension, System will create automatically. We need to tell the system about from when data is coming from, like import or Forms etc.
• IC - Inter Company - Which we need to tell system about the Entity as it is Inter Company or not.

In OneStream, like Hyperion we doesn't have Year and Time Dimension. Here only Time will dimension will get create Years along with Months like 2021M3 - Mar 2021

How to load metadata into EPM Planning Cloud

 To load metadata into EPM Cloud Planning applications

For example: Account dimension:

Go to Navigate (3 lines in left top corner), Go to Application then select Overview. 

Next select Dimension tab, Select Cube (depends on dimension and cube preferences)

Then select Import option in the right side.

Then Select Create Option in the below page

Once you click on Create, you can see below page.

Select File location is Local or Inbox, Choose Local if you have your file in your local machine.

Then browse the file and click on Validate. If validation is successful then click on Import.

You will get pop-up as Import Metadata is successful.

Thanks,

Madhu