Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Accessing reports from the Internet

Accessing reports from the Internet

Accessing reports from the Internet

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.

RE: Accessing reports from the Internet

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="http://server/CustomInterface/report.asp?reportid=23874928374237432&uid=spanah&server=SERVERNAME&port=0&project=My+Project"; 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.



RE: Accessing reports from the Internet

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.

RE: Accessing reports from the Internet

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.

RE: Accessing reports from the Internet

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.

RE: Accessing reports from the Internet

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.  


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close