Accessing reports from the Internet

[spanah]

I am trying to incorporate some reports from Microstraegy 7 on my jsp pages. I need to be able to securly provide reports to users based on their id (row level security, etc.). Options include:

1) sending them over to MicroStrategy web
2) use API's to recreate the type of MSTR Web functionality

The issue with option 1 is: how do I call Microstrategy web and pass user information in order to avoid another logon.

The question with API approach is what does it normally take in terms of development effort to get these reports embedded in my jsp's with calls to the Intelligencve server.

Your thoughts and advice are greatly appreciated.

 

[chael]

Are you running Web Universal or standard ASP MicroStrategy?

There are technotes that describe how to do pass-through logins...should be enough info to get you started. As far as how to integrate the urls into the interface...pretty easy to do -- maybe you can do something like this:

<IFRAME SRC=&quot;

http://server/CustomInterface/repor...er=SERVERNAME&port=0&project=My+Project&quot;

Height=500 Width=800></IFRAME>

There are only a handful or params that need to be passed into the URL, project, server, reportID, and UID are key...if you need to, you could grab the userID from the HTTP Header, and any other custom headers.

You can take 2 approaches: tear down the components not needed in the OOB interface, or build it up from the API. The SDK and the manuals have lots of code samples and you can build a simple interface pretty quickly using the API.

Good luck.

Chael


Chael

 

[nlim]

there are report beans that you can use with Web Universal. Much easier login, data manipulation all done for you. Check out their documentation if you have the license.

 

[spanah]

Thanks a lot for your advice - it's a pleasure to be chatting with experts.

We are running Web, not Web Universal. I was concerend about passing UID's in the URL because of the issue of authentication. I can authenticate the user and THEN send them over from my jsp. But they won't have a live Intelligence server session, right? The other concern with that was if they did have a live session, and they manually changed the userID to that of someone else's (who might also be live).

As you said, the tech notes will be helpful. Unfortunately, I have not yet gotten permission to go to tech support from my client - still working on that.

Thanks again.

 

[nlim]

MSTR uses sessionids instead of UID.

At some point in your workflow you will need to pass a UID to the MSTR system, but you can do that as part of your own JSP pages. The MSTR system will return you a sessionid to use for the rest of that user session.

good luck.

 

[chael]

There is very good technote specifically related to passing a UID into a MicroStrategy page, and then integrated (populating) the aConnectionInfo array with the proper params to ultimately create a sessionID. This is one approach. If you want to use the API to create a session, and then pass the session in, then that too is fine. There are many ways to do it.

The MicroStrategy manuals and support site will be very helpful in developing a solution.

Chael