I was wondering if there was a way of creating a variant for a web report, the way we can create one for a BEx report. I would like to be able to store the variable values in a variant and then select one of the avaialable ones.
With the current functionality, you cannot create a variant for the web report as you can do for the BEx excel based reports. Youc an however use any variants that have been created for the bex reports, in your web report by adding <b>&variant=demo</b> to the end of the URL, where demo is the name of your variant. Still I would say that this is not a very useful way out if your template has more than one data provider...
THanks for the reply. But I am still a bit lost as to where to add the &<b>variant=demo</b> part. I tried doing that at the end of the <i><link href="/sap/bw/Mime/BEx/StyleSheets/BWReports.css" type="text/css" rel="stylesheet" /></i> in the body, but the varaint does not show up. And if I have more than one variant for a query, Do I repeat the &<b>variant=demo</b> for each of the variants? and where does this selection option show up.
I know I have asked a lot of question, but do appreciate your help in pulling me through this.
You would need to add &variant=demo to the end of the URL that is generated for the web application, i.e. you can see in your IE browser. So once you can run for variant Demo, then Demo2 etc. No coding is required in the web application HTML code.
Thanks man, that helped. But again does that mean that I cannot have a dynamic selection of the avaialable variants at the runtime and shd have different URLs(effectively different Reports) provided for each of the possible variants?
Hey Andrzej,
Sorry abt my ignorance but I am not sure abt the "Save View" button. Could you please elaborate it further. Where is the Save view available, and how can I use it.
Yes, that's what the shortcoming is...you cannot see all available variants and pick from them. This method assumes that the user knows which variants are available for which report. But as you mentioned, you can have different URLs...
I am using BW 3.5 and standard web template is 0ADHOC, after filling selection criteria and excuting query I can see 'Save view' button under report name on 'data analysis' tab
You can save a view of report with current selection criteria but execute this view only in BEx.
To execute views in web report you have to modify standard web template in Web Application Designer in the way I wrote before
I am using the BW 3.1 version. Do you know, if this functionality is available with this version? 'Coz I dont see and "Save View" button or "Data Analysis" tab at the selection screen of the Web Report.
The save as view functionality does exist in BW 3.x. The only difference is that it is not available as a web item. There is a template named 0publishing_template. This has the save view option available. The other way is directly from the Web Application Designer. Go to Tools --> View Definition --> Select either based on a query or based on another query view. Once this is done you can either create another web template with the view as your dataprovider or you can create a hyperlink in the role menu and use a URL like this:
One thing to note is that views will save the variable entries. You can add VARIABLE_SCREEN="X" to force the display of the variable screen. To change the values in the variable screen add VARIABLES_CLEAR="X".
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.