Thoughts and help please.

[#1]

We have a portal(website kind of) built out of Cognos which has links to different cognos and excel reports.Now we wnat to build the same portal in qlikview with same report links..All the links will direct to cognos reports based on the user selection.Can I do that in Qlikvie?If yes how can I do that?How ca I put the report link here and point that report link to cognos reports?

Please share your thoughts  and advise.

Many Thnaks.

[sudeepkm · Accepted solution]

In QlikView you can build a web look alike page with bunch of report links (hyperlinks) using Action > External > Open URL. Provided the Cognos reports be available as hyperlinks.

And if you have some user authorization for specific reports, then you

1. can create a table with which user can see what all links

2. and load it to QlikView and in the QVW get the User ID by using OSUser or QVUser

3. And then just show those links as per the logic defined in the table

[#3]

Sudeep,

Thank you very much for your help and thoughts.Once I start developing I will have more questions for sure.Thank you again.

Thank.

[#4]

Hi Sudeep,

Since I ahve started developing the Portal I have links based on role(user authorized).Can you please explain me how can I do this again.I dont have one qvw which itself is a portal.

Thanks in advance.

[sudeepkm]

My idea was to create a QVW file which will be having external links to Cognos reports.

This QVW can be hosted on QlikView Access Point.

Every QVW hosted on Access Point has a direct URL so you can share the direct URL of your QVW with the end users so that they can bypass the Access Point and can open the QVW file which behaves like a web page.