cancel
Showing results for 
Search instead for 
Did you mean: 

BW query variable in hana studio

KALAISELVI
Participant
0 Kudos

Hi,

I am using bw 7.5 sp8 and i have created bw query on top of composite provider using hana studio.For the characteristics filters,i have created variables based on infoobject by using below

1)hana studio-project explorer->rightclick->variable->ztest-manual input,single value based on infoobject A;it doesnot appear on on filter tab when i restrict characteristics

so tried with other method

1)hana studio->query->rightclick->variable->manual,single value,based on infoobject A but again not appeared on filter tab when i restrict characteristics

but

1)se11->RSZGLOBV table has created variable in A&M version

2)in queries->infoprovider view->drill down-<characteristics value variables-new variable created by above methods appear but when i drag and drop on characteristics filter query throwing error variable doesnot exist or incorrectly used in filters

Accepted Solutions (0)

Answers (3)

Answers (3)

ikirilova1
Participant
0 Kudos

If you want to use the variables in prompts, they must be defined as Input-ready.

In BW modeling tools find the variable in InfoProvider view, open it and set the check in the General tab.

Luckily, I was here for another thing and I found it in the question 🙂

sri_pamarthi
Participant
0 Kudos

Hi Deepthi,

if possible Please share some screenshot to have more details.

However, can you please check what is the base object utilized for 0quipment_0calday

Thanks & Regards,

Ram.

sri_pamarthi
Participant
0 Kudos

Dear Deepthi,

Suggest you to please create Variable under the Infoprovider -> Characteristic -> Create Variable, once respective variable got created just apply save.

While applying the filter on characteristic under the restriction , same variable will be visible.

Thanks & Regards,

RAM.

KALAISELVI
Participant
0 Kudos

Hi Rama,

Thanks for your input.My problem is when i create variable for attribute it is not available when i try to use under filter in navigational attribute.Consider i created variable for 0calday and i query filter tab,i dragged and drop 0quipment_0calday,that variable is not available and i need to create new variable for 0quipment_0calday but i assumed if variable for base object is created we can use for navigational attribute also