• State Suggested Answer
  • Locked Locked
  • Replies 7 replies
  • Answers 2 answers
  • Subscribers 95 subscribers
  • Views 6244 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Create Report Subscription script

piotr.markiewicz
over 7 years ago

Hello, 

I need to create the report subscriptions from script/process. 

I have a number of reports that are bundled as a standard package. All of them should be assigned to users automatically.
User can opt out from those subscriptions at any time. 

Is there any way to do this from script/process?

I've tried inserting records using object browser manually, the insert action is prevented (permission missing). 

If there is no out-of-the-box method, what records (in which tables) I should insert to create subscription manually?

 

Thanks, 
Piotr Markiewicz

Parents
  • 0 over 7 years ago

    Just as a clarification.

    The table PersonHasRPSReport does not store the report subscription itself. It stores the access of a person to a subscribable report. So if a person has an entry for such a subscribable report here, the person is allowed to create a subscription to this report in the web portal.

    So, if everybody should be able to create his own subscriptions you just have to assign the subscribable reports to either an application role or business role that everybody is a member of.

    The subscriptions itself are stored in the tables RPSSubscription and RPSSubscriptionCC. But you have to keep in mind that a subscription consists of the subscribable report and of the defined, calculated or selected parameters for the report. These are stored in different tables as well.

    If everybody should be able to get a report with the same parameter set, the best practice would be to create a subscribable report (RPSReport) that defines all parameters as desired and having the parameter type set to fix or calculated.

    HtH

Reply
  • 0 over 7 years ago

    Just as a clarification.

    The table PersonHasRPSReport does not store the report subscription itself. It stores the access of a person to a subscribable report. So if a person has an entry for such a subscribable report here, the person is allowed to create a subscription to this report in the web portal.

    So, if everybody should be able to create his own subscriptions you just have to assign the subscribable reports to either an application role or business role that everybody is a member of.

    The subscriptions itself are stored in the tables RPSSubscription and RPSSubscriptionCC. But you have to keep in mind that a subscription consists of the subscribable report and of the defined, calculated or selected parameters for the report. These are stored in different tables as well.

    If everybody should be able to get a report with the same parameter set, the best practice would be to create a subscribable report (RPSReport) that defines all parameters as desired and having the parameter type set to fix or calculated.

    HtH

Children
No Data