Question Re: Sap Analytics cloud giving error while populating data using two different models in Technology Q&A

Sap Analytics cloud giving error while populating data using two different models

former_member783203 — Thu, 21 Apr 2022 07:49:46 GMT

Hello,

I have developed two different models, one for the data and the second for the hierarchy. Data gets populated when I use standard measure from Model 1 with Hierarchy from Model 2, but I face errors in two different cases.

Case 1: When using a calculated measure from model 1 with the hierarchy of model 2.

Error:

Case 2: When using two dimensions from model 2 in the single visual.

Error: It shows data corresponding to one dimension and show no value for the other dimension.

Re: Sap Analytics cloud giving error while populating data using two different models

dskiendziel — Thu, 21 Apr 2022 12:01:22 GMT

So, you have the Account dimension (my assumption) in one model that has a flat hierarchy (no hierarchy) and the same Account dim in another model with a structured hierarchy?

Re: Sap Analytics cloud giving error while populating data using two different models

former_member783203 — Fri, 22 Apr 2022 10:46:32 GMT

Yes, Dan, I used two models and connected them using code to a data to a heirarchy.

Re: Sap Analytics cloud giving error while populating data using two different models

Sowmiya_C — Sat, 23 Apr 2022 08:13:29 GMT

mashar419,

Have you connected the Id's of the dimensions from both models?

Re: Sap Analytics cloud giving error while populating data using two different models

former_member783203 — Mon, 25 Apr 2022 04:43:52 GMT

Hi Sowmiya,
Yes, I did connected the Id's, attaching ss below.

Re: Sap Analytics cloud giving error while populating data using two different models

Sowmiya_C — Mon, 25 Apr 2022 12:08:30 GMT

mashar419,

My assumption is that you have linked the dimension from both models.particularly we have to link the Id's from both the dimension to get a perfect result as shown below.

Re: Sap Analytics cloud giving error while populating data using two different models

former_member783203 — Tue, 26 Apr 2022 20:12:30 GMT

Yes, I have connected them using ID. Although I am facing no issue while using hierarchy when having a standard measure, only when I am using a calculated measure then It is showing an error that I am attaching.

I have also check at all drill level, but facing same error throughout.

Re: Sap Analytics cloud giving error while populating data using two different models

dskiendziel — Sun, 01 May 2022 18:47:41 GMT

Sorry for the late reply. My main reason for the question was to understand why you would have the hierarchy in another model? Does the model with the hierarchy serve any other purpose than to supply the hierarchy to the other? Why wouldn’t you have the hierarchy in the same model? I know there can be problems using blended data in a chart, so i try to avoid. This does not answer your original question, just trying to understand the context better.