Skip to Content

excel as data source for measures in sap strategy management design

hi sap experts.

i recently start working with sap strategy management.

i need your helps.

when i create a measure in measures (in strategy management design ) i want to use an excel file as my data source.how can i do it ?

my object is to design a scorecard and its details like (perspectives and objectives and measures...) and see the result, is there any source help that you can suggest me ?

thanks for your helps.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Oct 21, 2015 at 09:33 AM

    Hi

    You can have 2 ways loading data from Excel.

    1. Entry And Approval (E & A)

    2. In PAS using Link ID.

    You can also use SMDataLoader.xls for loading perspectives, objective & KPI names also.

    You can use Cubebuilder for designing PAS Model.

    1. Create Model Using Cubebuilder.

    2. Create or Load using SMDataLoader all Score Card Items reqd.

    3. Assign KPIs / Measures to PAS measures while configuration.

    4. Load Data either from E & A or Directly into PAS.

    5. View Score Card

    Rgds

    Sri G


    Add comment
    10|10000 characters needed characters exceeded

    • hi and thanks for your reply.

      i search about PAS and LINKID .

      i understand if i want to create one pas, i must have SSM folder in sap folder in my program files.

      i dont have this folder. is this mean that i dont have install sap strategy management ?