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)
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.
what about getting all the details for all the users through query then i split the output using "bursting"?
what do you think.. 8)
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.
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
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