SAC Warning: this link can be used for filtering but not for blending

[hre]

I want to link 2 data models via several dimensions. One dimension is based on a public dimension with a hierarchy.
I got the warning that this dimension is not usable for blending, only filtering. Is it because of hierarchy ? How could I solve the problem, I need blending and the hierarchy in the pubic dimension!

Thanks for help.

[Qliksense_Ultra]

Just came here. It shows again that, even 2 yrs later, SAC is still in open BETA test...

[VijayetaSharma]

Hello rcg53721,

When you are linking dimensions you are performing either browser based blending (when one or all data source are live connection) or native blending (all import model).

Unfortunately you are not allowed to blend on Hierarchy columns yet. This is know limitation and you find find more details in help document here:

Help.SAP : Data Blending

Here is an enhancement waiting for 15+ votes to be considered for possible enhancement. Feel free to vote on it.

https://influence.sap.com/sap/ino/#/idea/266740

Reuest is created with respect to SAP BW live connection, thought restriction is with hiearchy is common across the board when it comes to blending.

Workaround : If you are on import model then you can try to duplicate this columns with a flat one and use that column for blending/ linking and the hierarchy for display in stories.

Don't forget to up-vote and accept, if it helped. 🙂

Thanks,

Vijayeta

[VijayetaSharma]

Hi rcg53721

ID wont help. Not sure if you checked my reply on restriction yet.

Thanks,

Vijayeta

[hre]

thanks , this helps, and I will vote for this feature!

kr Holger

[VijayetaSharma]

rcg53721

Would you mind accepting the correct answers. This way other will be able to find it quickly.

Thanks,

Vijayeta

[N1kh1l]

rcg53721

This error comes when two models are not from the same system. see SAP Note below.

2739665 - SAP Analytics Cloud does not display measures and dimension on linked models | SAP Knowled...
There are also some restrictions when setting up data blending.

2925623 - Considerations when using Blending Data (Creating Linked Dimensions) in SAP Analytics Clou...

3143834 - Blending Restrictions in SAP Analytics Cloud (SAC) - SAP ONE Support Launchpad
3214571 - Unable to link dimensions in the story with multiple account dimension hierarchies in SAP ...

Please upvote/accept if this helps you.

Nikhil

[hre]

I think it is

• Blending on ID between hierarchies

I tried to blend on another member (not ID) of this hierarchy, but without access.
I will bring now this hierarchy ID as separate dimension into each modell. No other chance to blend the data.

thx Holger

[N1kh1l]

rcg53721,

You will need a flattened out dimension with no hierarchy

[hre]

Hi Nikihil, both modells have the same source system , MS SQL Server, only different views on this server. This could not be the reason.

[N1kh1l]

Below are some known restriction while blending. Just see if you are violating any.

• Blending across multiple HANA on-premise systems
• Blending on Date
• Blending on ID between hierarchies
• Blending on attributes to dimension

• Apply page filter / input control on second dataset
• Linked Analysis

• Planning

• Currency conversion
• Tuple filters
• Display of Totals
• Top/Flop N
• Sorting

• Create variances on blended calculations