Xcelsius BW

[Former Member]

Hi,

Xcelsius with SAP bw when user run the dashbord he/she see the variable screen but i also want when he /she is in the dashbord and select a filter or any selector then one seprate query needs to be excuted or same with new selection but not with the variable screen

is it possible to call some other BW query when user is already in the xcelsisu?

Regards,

Sanjeev Kumar

[sriramvijay_ravidoss · Accepted solution]

Hi Sanjeev,

It is possible.

You can have as many as SAP netweaver BW connection in a xcelsius file.

but all the connections can be made to same system only.

Variable screen will be shown if there is a mandatory variable in the Bex query.

To avoid intial variable screen we can give default values to the mandatory variables.

By using the refresh button or Usage tab of a connection in data manager, we can refresh the same connection or some other connection (i.e) call same BW query or some other BW query when user is already in the xcelsius without variable screen.

Variable screen will be shown for the first time of execution only.

regards,

Sriramvijay.R

Edited by: Sriramvijay.R on May 10, 2011 10:32 AM

[former_member809313 · Accepted solution]

Thanks Sriramvijay.

so you are saying that we can triger the query with the help of triger Cell option rrite ?

and second when i want to avoid intial variable screen and give default values to the mandatory variables , it still appaer to the user , is i am missing something there ?

[sriramvijay_ravidoss · Accepted solution]

Hi Sanjeev,

yes, we can use trigger cell option to refresh automatically or we can introduce a new "connection refresh button" from components window and ask user to refresh manually.

to avoid variable screen giving default value to mandatory variables is the option,

After giving default values, Please re-import the query structure into xcelsius once again and check

if it not works, check all the variables once again in the Query designer,

please let me know abt this,

regards,

Sriramvijay.R

[sriramvijay_ravidoss · Accepted solution]

Hi Sanjeev,

If you are using any variable restriction in Keyfigures. you have to give default values to those variables also.

regards,

Sriramvijay.R

[former_member809313 · Accepted solution]

I have many local selection and res. keyfigure , may be thats why i am not able to hide the variable option.

any other way to avoid the variable screen ?

thanks.

sanjeev Kumar

[sriramvijay_ravidoss · Accepted solution]

Hi Sanjeev,

You just need to think about variables which are shown in Variable screen.

How many variables it is asking in intial screen?

Among that how many are coming with * (i.e) mandatory?

If you have some exit variables then Give default value in I_step=1.

I think for other methods portal administrator may be able to help, while creating I views in EP.

Regards,

Sriramvijay.R