'Web Elements 2.47' - Report update issue

[Former Member]

Hi,

Recently, while working on the drop-down select feature of web Elements, on selecting a value from the drop-down list & clicking >>update in the Business object CMC the page points back to the the login screen & doesn't update the report.

code: @Selection

stringvar path:=WETargetPath ("rpt", "Name", "Report", "");

stringvar allelements:=

WESelect ("term", "All|201109|201202", "All|201109|201202",{enrol.term}, "") +

WESpace(3)+

WESubmitLinkSelect("update the report", ">>Update", path, "");

allelements + WEBuilder (allelements,3)

It displays the URL when in production mode '2' correctly. Is there some plugin missing or does it have to do with some configuration.

Also, where can we find examples of how to pass the database variables to the charts and different tables in the report using web Elements, solely.

-- R Pere

[JWiseman]

hi R Pere,

usually the cmc logon screen would only appear when there is a logout / token expiration issue. i.e. the error doesn't really have anything to do with webelements as they only create a hyperlink and don't directly affect anything to do with sessions.

as a comparable flow, write down the opendocument url that is generated in mode 2 and then create a new hyperlink with that exact code. if you press that hyperlink on your report, this would basically be the same thing that the webelements functions produce, which is a report to report link. timeouts would be caused by other issues such as session settings in the cmc.

in order to affect charts and tables, this is still the same workflow as before where you have a parameter in your target report in the record selection filter, or a parameter which affects group sort, or a parameter which affects group selection. webelements create the controls and then the opendocument url which open the target report. so in your report design, you would start by creating those parameters which change your charts and tables by referencing the parameters in your record selection formula, and then in the report that contained the webelements controls, you would have those controls have the identical names as the parameters in your target report.

-jamie

[JWiseman]

p.s. here's where you can get a sample report with webelements where the report has a chart as well as other objects.

[Former Member]

Hi Jamie,

Thank you for your reply and taking the time to post the example too. However I haven't been able to get rid of that error, where on update the page redirects to the logon page instead of refreshing the report. Tried a simple report and tested using the example you recommended, seems like its a configuration error and is there some check guide to make sure the report viewer in the CMC is configured well.

Also, while creating dynamic parameters to pass to the formula thus, updating the visuals like graphs etc.; the dynamic parameters don't seem to work they yield an error "Failed to read parameter, etc. " While using static parameters it helped to get rid of the the error. But is there a quick fix to this issue to all passing dynamic parameters in the formula and then update data tables/graphs.

I hope to be be able to isolate the two issues and solve them ASAP, especially since the reports can't be tested without viewing results as th link on update takes one to the Info-viewer logon screen. (Check Database configurations too.) Using CR 2088, version 12.0.0.683

[JWiseman]

for the first error, please repost to the bi platform forum as the issue has to do with opendocument (not a webelements issue) and infoview sessions.

for the second issue, you'll also need to create a new discussion as per the forum rules...i.e. one question / issue per disucssion. please provide more info on this though in the new discussion as there isn't much to go on.

-jamie