Web Analyzer (BW 7.0/Netweaver 2004s/Java)

[Former Member]

Hello,

Does anyone have a suggestion on how to ensure that the "Web Analyzer" pops the "Variable entry screen" prior to query execution (for queries that use variables)? I have to imagine this is possible.

Currently I am able to get the "Variable Entry screen" to pop only once, and for each subsequent query execution the previously entered variable value gets re-used transparently, but I am not able to input new or different values until after query execution.

So far I understand that popping the "Variable Entry Screen" is a web template property, but I imagine someone has found a way to work around the limitation of the variable entry screen only popping once and not for each subsequent query executed in the same session.....or perhaps someone has found an alternate solution.

I have been struggling with this issue, and would really like to role out Web Analyzer as a complementary tool that can be used as a parallel alternative to BEx Analyzer (within Excel). I think the variable window is really the only issue holding us back.

Thanks!

Nick

[former_member184494 · Accepted solution]

Are you using the 3.x web analyzer or the 7.0 version...?

[Former Member · Accepted solution]

Hello Arun,

We are using the 7.0 (Java) version of Web Analyzer. We enter Web Analyzer via the portal > Click on the 'Business Intelligence' tab, then click 'Bex Web Analyzer'.

Thanks!

Nick

[Former Member · Accepted solution]

Open the web template using WAD and under the web template properties (on the left hand side) you see an option "Display variable screen ", Check the box and save the template. Now you will get a variable pop up screen everytime you run the report.

[Former Member · Accepted solution]

Hello Hansa,

The problem i run into with that method is that if I open another report i do not get the variable screen pop-up. It will only pop up for the first execution. Any and all reports that are opened from within that same template will then not pop the variable screen.

I have actually talked about that behavior on another thread on which I posted a similiar but slightly different question:

[|]

Thanks!

Nick

[Former Member · Accepted solution]

if you are using Query view selection item in the template for different query views. Go to the properties of the Query view Selection item -> Data binding->Selection of query views ---> uncheck the option for keep filter values. This should allow you to pop up variable screen for every query view you slect to run.

[Former Member · Accepted solution]

Hello Hansa,

Thanks for the suggestion. I reviewed the option you described and found that 'Keep Filter Values' was unchecked.

I am using a direct copy of 0ANALYSIS_PATTERN. Z_0ANALYSIS_PATTERN, thus all the settings and parameters are exactly the same as delivered with the exception of the Web Template parameter 'Display Variable', [VARIABLE_SCREEN] which has been checked to 'On'.

So no luck yet

The variable screen does pop, but only when there are variables that have not yet had a value input for them on any previous query. Since the queries that my users execute vary greatly, sometimes entering 2010 for the fiscal year is fine, but on other queries it leads to a time out. That is why I need to ensure that the users see the variable screen between each query execution that uses variables.

Thanks for the suggestions!

Nick

Edited by: Nick Bertz on Mar 12, 2010 1:11 PM

[Former Member · Accepted solution]

Nick,

Why dont you use a BI command in the web template to trigger variable screen when your users click on a query.

Thanks

Hansa

Edited by: Hansa on Mar 12, 2010 8:59 PM

[Former Member · Accepted solution]

Hello Hansa,

That might work....Can you help me do that? Or is there a well written Blog or thread that clearly explains how to do that?

My WAD experience is minimal.

Thanks,

Nick

[Former Member · Accepted solution]

Nick,

My assumption is you are uisng query view web item in your template to call different queries/query views. If not let me know how you are calling different queries from the same template.

Thanks

hansa

[Former Member · Accepted solution]

Hello Hansa,

I click a button that says 'New Analysis', That brings up my query history, i can then select a Query, or i can change the 'type' drop down box to 'View' and select a View in my history.

I select the query and click OK, then it executes.

Again i am using a copy of the standard 0ANALYSIS_PATTERN template. I am not sure exactly how to dissect it any furthur, that template has a lot of items appear in the web application Designer.

Thanks for keeping on this one!

Nick

[Former Member · Accepted solution]

Nick,

I did a simple test as you did and it worked for me. I copied the original 0ANALYSIS_PATTERN template and the setting I made were as below

Web template properties:

1. Display variable screen: Unchecked

2. USE_SPECIFIC_VARIANT_CATALOG: Unchecked

3. Reset variable values to default: Checked

4. Display same variable for different queries: Checked

5. Show personalization: unchecked

Go to properties for BUTTON_OPEN_SAVE web item

Click on 1st text which has "757" button, opens up a new window. Click on command which opens another window.

Here you insert another command by htting button "next" ...Now you see a button "Next command" -> Button Insert->Go to All Commands tab -

---

>under commands for web templates check option "open variable dialog". Go to favorite command select "Open variaible dialog" and hit next -> click on OK button-> Clik OK again---->Click ok again.. Now save the web template. This shoudl do the trcik for you. Hope it helps you.

Thanks

Hansa

[Former Member · Accepted solution]

Hello Hansa,

I think what you described is exactly what I needed. I am going to test with it for awhile and post back (i don't forget points!).

Thanks a lot for your help!

Nick

[Former Member · Accepted solution]

Hello Nick,

I've the same request.

Does the solution provided by Hansa solve your issue ?

Thanks in advance for your answer,

Mai

[Former Member · Accepted solution]

Also please refer to [|]

[owen_carnes · Accepted solution]

I made these changes, but if I open a query that has been saved in the BEx Portfolio after these changes, it still immediately runs the query, the variable entry screen doesn't pop up.

I have the iView for the query set to pop up the variable entry screen from when I published it to the portal.  However, when I run the query, then save it, and the open the saved version, this is when the variable entry screen doesn't appear.

Any ideas how I can get the Variable Entry Screen to always appear?

Thanks,

Owen