Best Approach ..!?

[SupCog]

hello there,

i need to know different approaches from you to do the following:

creating Cognos report that would be ran with different users, the output report will list all details related to the user who ran the report. example: user1 and user2 would ran reportX, the output will list: User1 Details for user1, User2 Details for user2.

i read about Bursting reports. also, i have a thought of using the credentials for the users within the report to distinguish the corrsponding output. which approach is the best do you think?  8)

   

[bdbits]

Bursting is not for filtering data, it is for splitting output from a report to deliver particular parts of it to different users.

You will want to filter the data based on the user.

[SupCog]

what about getting all the details for all the users through query then i split the output using "bursting"?
what do you think.. 8)

[bdbits]

If you want to run it for all users and deliver it to each one, e.g. a PDF sent to each one, then that is a candidate for bursting.

If you want user1 to interactively run a report and see a different result than when user2 runs it interactively, that would likely be filtered data based on something about the user.

It just depends on your requirements.

[BigChris]

You could also consider using the data security in Framework Manager so that the data is always filtered by user...then you'll have reports that are effectively prefiltered

[SupCog]

Sounds good!

my requirements as you said:
I want user1 to interactively run a report and see a different result than when user2 runs it interactively

What if I want to send the report result by email to each user with his corresponding details? if I use the security option in FM then should I use the Bursting report also?

thanks  :D