BO Universe on HANA - Input Parameter Default Values Issue

[SamanthaGuzman]

Hello experts,

I have a HANA calculation view with two input parameters. All of them have default values, example:

input parameter XX - default value '001'

input parameter YY - default value 'AAA'

You can enter of course other values for these input parameters and the data preview returns data acording what you choose in the prompt.

I created an universe on this HANA CV with also two parameters and at query script END_SQL in the business layer:

WITH PARAMETERS ('PLACEHOLDER' = ('$$HANAInputParameter1$$',@Prompt(Parameter 1)), 'PLACEHOLDER' = ('$$HANAInputParameter2$$',@Prompt(Parameter 2)) )

But it does not work, only data for the default values are available in the query results at universe of webi level even if the user chooses in the prompt other values for these fields,

I unchecked default values in data foundation and also does not work.

How can I solve this issue? It's about a syntax error at END_SQL? Removing the default values at HANA CV level, what about the performance? Is there something I'm missing?

Thanks a lot in advance

Samantha A

[denis_konovalov]

I have fixed your tags. Please select more careful next time.

[former_member233723]

Hello Samantha A,

So your requirement is to not display any default value in WebI? Have you tried to remove END_SQL and just disable the default value at Data Foundation then save then export back to repository the universe?

Thanks,

Mate

[SamanthaGuzman]

Hello Mate Komaromi,

Thank you very much for your comment.

No, my problem is, the query displays only data for the default values of the HANA View InputParameters. Query in Universe and in WebI.

It means:

If I have InputParameterYY with default value 'AAA' in HANA , and I choose in universe query or WebI prompt another value for this InputParameterYY like 'BBB' or 'CCC', the query displays data for default value 'AAA', not for what I chose.

Samantha

[former_member233723]

Hi Samantha,

Let me internally look into the same and get back to you with some next steps.

Thanks & Regards,

Mate

[former_member233723]

Hi Samantha,

I checked it internally, for me it it's seems ok, i.e. retrieves the correct values depending on the parameter passes to HANA.

Do you have any special reason to have END_SQL also beside the HANA Input Parameters? As because for me it seems the culprit is with the END_SQL parameter has added to the business layer parameter.

Thanks,

Mate

[former_member896414]

Hi Mate,

Similar is the behavior if I consume HANA views directly in Webi without universe. I am using BI Platform 4.2 Support Pack 7 Patch 1.
I have a HANA view with Star Join wherein I am joining with a Dimension view which has an input Parameter mapped to a constant. Now whatever constant value I map to the Input Parameter, Webi ignores this mapping and always executes with the default value of Input Parameter in the Dimension view.

Dimension views: VDIM_XX
with Input Parameter IP1
IP1 default value "X"

Calcualtion View: VCV_XX

with Star join using VDIM_XX

IP1 mapped to constant "Y"

When WEBI over view VCV_XX is executed, it ignores IP1 mapped to constant "Y" and runs with default value "X".

MDX script:

SELECT NON EMPTY {[Measures].[CC_Annualized],[Measures].[CC_Ratio],[Measures].[CC_YTD_Dep],[Measures].[CC_Years],[Measures].[CC_GrossAssetS2]} ON COLUMNS, NON EMPTY Crossjoin(Crossjoin([RACCT].[RACCT].[RACCT].Members, Hierarchize({[VDIM_XX].[FSV_HIER].Members})), [YEARS_PER_POLICY].[YEARS_PER_POLICY].[YEARS_PER_POLICY].Members) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON ROWS FROM [VCV_XX] SAP VARIABLES [Ledger] INCLUDING '0L' [Company_Code] INCLUDING 'ABC' [Profit_Center_Type] INCLUDING 'PQR' [Reporting_Year] INCLUDING '2019' [Reporting_Period] INCLUDING '001' [Currency_Type] INCLUDING '30'