Datasphere - Association to a dimension with input parameter

[jorg_vdst]

Hello,

Starting from a Fact view, Is there a way to associate a Dimension that has an input parameter? When I try to do it, I get the following message:

These input parameters have no mapping or value defined

I don't think there is a way to map this parameter to the Fact view in the interface. Maybe something is possible in the annotations?

Thanks for any input.

[Sebastian_Gesiarz]

bump

[mitko1994]

Did you find a way to do this? I'm also stuck in the same situation where I want to create an association to a view which has an Input Parameter.

[Sebastian_Gesiarz]

has anyone found a workaround?

[mitko1994]

Not possible I'm afraid! The workaround would be a view with a join.

[85723057325]

The only non-SAP standard workaround I can think of is a flatter table structure specifically taylored to the Data Model's needs, e.g. join the parameter dependent variables directly into a flat denormalized fact table, which is the direct input of the Analytical Model (association to dimension replaced by join into denormalized fact table), and setup a parameter there.

[85723057325]

This seems to not be supported by SAP Datasphere with unclear product roadmap, does anyone from SAP have any other insight?

It is a rather urgent topic arising with many clients.

As a developer, you assume a parameter can be created for associated dimensions, also retrospectively like this:

* Delete all upstream associations,
* Add parameter in affected table and use it
* Re-create all upstream associations

The data model shows "model definition looks good" and everything is green.

But then once you deploy the error "not supported" arises.