Model and story SAC do not show data after making changes in hana calculation view

[pamarque]

Hi Guys,

I have a story in sac whose model is a model created from a live connection to a hana database, and the view that my story consumes is a cube-type graphical calculated view. This view in turn is created from other calculated views. I have made a modification in one of the calculated views that had a join of type inner join and I have changed it to left join. After this change The calculated view in HANA shows data correctly, but nevertheless the story in SAC after making this change, does not show me data in the graphs. After several tests, I have managed to see that the problem is in the SAC data model, it is as if it had been corrupted, since I have created another model in SAC, a copy of the original, and this one does show data in my story, But I would have to do all the graphics again. What could have happened? How can I restore the model so that my story works and I don't have to do the graphics again?

BR,

Patricia

[mfoeken]

Hi Patricia,

Can you try to re-save the model? So not create another model using save as, but simply open the model and save it?

Kind regards,

Martijn van Foeken | Interdobs

[pamarque]

Hi Martjin,

I've already done that. I have opened the model, I have saved it, and when I run the story, it does not show me data in the graphics. The HANA data model (calculation views) does have data, it is the SAC model that has become unusable after changes in the SAP HANA data source.

Could this error be an OSS note error? It is not normal for this to happen and it works like this.

BR,

Patricia.

[mayaboleto]

Hello Xavier,

please try this workaround at the following link

Best,

Maya

[mayaboleto]

Hello Xavier,

you are right this is working only with acquired data model.

[mayaboleto]

Hello,

please create a copy of your original story and a copy of the model that it is working. After having done this, open your story in edit mode and and go in the Data Section of the Story.

If you click on the model present you can find the option Replace .

Clicking there you can set your new model: if the dimensions/measures are equal you will not need to do anything (SAC will take care about everything without any further effort from your side).

Best,

Maya

[xjhacking]

Hi Maya,

Are you sure that this works for live models? If I try this on a SAP BW model the option is still greyed-out...

Cheers,
Xavier