Skip to Content
avatar image
Former Member

SAP Analytics Cloud Linked Model

My company recently subscribed BOBJ cloud licenses.

I have a doubt about modeling. I have a file with sales transaction as shown below and another file with customer group master data. As we recently did a many changes in SAP customer grouping my historical sales is not aligned with most recent customer groups. Is there a way I can design a final model for reporting sales data from transaction and map the customers to customer master data grouping?

I tried linked analysis by linking customer code as primary key and I can get customer grouping to my sales transaction, but the issues is every time I have to keep my customer as a dimension in my charts or visualization, and of course you know as the number of customer are more, keeping customer in chart is not practical.

Appreciate if you guys can help to me to create a model by linking both sales and customer groups together. I am attaching my sales and customer group files and a copy of final model what I am looking for

Thanks & Regards

Naushad

modeling.jpg (152.1 kB)
model.jpg (169.3 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Jun 01, 2017 at 01:34 PM

    Hello Naushad,

    Any Success on this ?

    Please share the method if you are able to achieve the desired model .

    Many Thanks !

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 03, 2017 at 05:38 PM

    Hi Nishant, No luck yet. will share with you if i get something.

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 09 at 03:37 AM

    Hi Naushad,

    Have you tried Linked Models ?

    Many Thanks !

    Add comment
    10|10000 characters needed characters exceeded