SAP Analytics Cloud Linked Model

[former_member419353]

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

[JohnL]

Hi Naushad,

I'm still unsure of your exact issue.

Can you describe it more?

[former_member456023]

Hi Naushad,

Have you tried Linked Models ?

Many Thanks !

[mnaushad]

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

[former_member305187]

Hello Naushad,

Any Success on this ?

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

Many Thanks !