Skip to Content
0

SAP Analytics Cloud Linked Model

Apr 12, 2017 at 12:24 PM

131

avatar image
Former Member

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)
10 |10000 characters needed characters left characters exceeded

Hi Naushad,

I'm still unsure of your exact issue.

Can you describe it more?

0
* Please Login or Register to Answer, Follow or Comment.

3 Answers

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

Hello Naushad,

Any Success on this ?

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

Many Thanks !

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jul 03, 2017 at 05:38 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Mohammed Ashraf
Mar 09 at 03:37 AM
0

Hi Naushad,

Have you tried Linked Models ?

Many Thanks !

Share
10 |10000 characters needed characters left characters exceeded