Followers

Tuesday, November 8, 2022

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


1 comment: