Information Design Tool Problem on HANA

building semantic layer
1

Hi experts,

I have a Calculation View in HANA database which has a Input Parameter.

I use the Information Design Tool (IDT) to consume that View, but I don’t know how to set the Input Parameter.

I can use IDT consume the Calculation View without any Input Parameter, but I have know idea with the Parameters one.

Anyone can help me? Thank you very much!

Kevin.Wang (BOB member since 2013-11-19)

2

Building a universe in IDT on SAP HANA has been made much easier in BI4.1 (prompts are automatically exposed) so I assume you are on BI4.0…
In 4.0 you will need to create a Derived Table in the Data Foundation. You will create all objects on this derived table & not the base column view from SAP HANA
The derived table syntax will look like:

Select * from "_SYS_BIC"."package/TABLENAME" ('PLACEHOLDER' = ('$$INPUT_PARAMETER$$' ,'value'))

this will hard-code the value sent to the Input Parameter. if you want to pass the input parameter to the end user you need to build a Prompt (potentially with a List Of Values) in the Data Foundation
Once you have build the Prompt you can change the Derived Table definition like this:

Select * from "_SYS_BIC"."package/TABLENAME" ('PLACEHOLDER' = ('$$INPUT_PARAMETER$$' ,@Prompt(myPrompt)))

buzz :australia: (BOB member since 2005-08-12)

3

Hi buzz

I’m sorry for my late reply, and thank you very much, it worked with your suggestion.

You’re right, I’m using BO4.0. I’ll try to use 4.1 recently.

Kevin.Wang (BOB member since 2013-11-19)

4

Hello Folks,
I having hard time finding the solution for what if I have two input parameters? how to handle in the universe(IDT)?
I did lot of research on the web and all the examples are related to one parameter.

I have following input parameters defined in HANA calc view:
Division
SalesOrg:

I tried to create derived table and using syntax :
SELECT *
FROM “_SYS_BIC”.“new/InvoiceTestQuery” (‘PLACEHOLDER’=(’$$Division$$’,@Prompt(Division)))
It is giving me error saying that SAP DBTech JDBC: [2048]: column store error: search table error: [34092] search on calculation model requires parameters;Required variable $$SalesOrg$$ is not set.
Basically it is looking for SalesOrg parameter.
How to resolve my issue. Any help would be appreciated.
Thanks
Remata

remata :us: (BOB member since 2006-04-19)

5

Hi All,
I am trying to pass a numeric prompt to users using placeholder through Derived table.
The syntax I am using is:-
select * from <view_name> (‘PLACEHOLDER’=(’$$name of the input parameter$$’,)).
In the above syntax for the prompt I have made a parameter which is number.When I try to pass that parameter in place of prompt definition in the above syntax it gives me error,but when i pass that parameter in single quotes the expression gets validated successfully.But I want to pass it as a numeric prompt and after defining the parameter as numeric how can it get validated when i pass it in single quotes.
Any help on this will be appreciated.
Thanks in advance.

User0207 (BOB member since 2013-09-21)

6

Hi,

I have two parameters but facing syntax issue in the following commang.
Kindly need help to solve.

(‘PLACEHOLDER’=(’$$IN_START_DATE$$’,@Prompt(Start Date)),‘PLACEHOLDER’=(’$$IN_END_DATE$$’,@Prompt(End Date)))

zenithreddy (BOB member since 2013-12-11)