Skip to Content
author's profile photo Sudhakar Reddy
0
Sudhakar Reddy

Dynamic Scheduling on Webi Reports into Fileshare

Posted on Jun 27, 2016 at 07:30 AM 44 Views

Hi All,

In BO 6.5, the reports were dynamically scheduled to File Share as PDF using VBA Macros.

Ex: I have report (abc.rep). The selection criteria are Code and Year. The code and year is provided to the report by the Macro

which reads from the database. If Code = ‘X22’ and Year=’2014’, the report is executed with this selections and another macro

runs to save this file as PDF in file share path. Here the twist is the Codes keeps changing, suppose in this month if the

Code=’X22’ and year =’2014’, next month it can be Code=’Y22’ and Year=’2014’.So this keeps changing dynamically and reports

are also saved into folders based on this. This works fine in BO6.5 using macros and BCA.

Now that we have moved few BO 6.5 report to BO 4.1. , I need to implement some logic in 4.1 to produce the results in the same manner.

Since Macros doesn’t work in 4.1, iam looking into the ways to achieve this. If anyone gone through this kind of task,

please share your thoughts.

I have gone through many posts but could not find the apt solution.

Regards

Sudhakar

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Dell Stinnett-Christy
    Dell Stinnett-Christy
    Posted on Jun 27, 2016 at 01:45 PM
    0

    If the rules for this are well defined and based on the current date, you might be able to dynamically set the parameters by creating a filter in the universe instead of using actual parameters.

    If that's not possible, you may have to use either the Java or .NET SDK to schedule the report with the correct values.

    -Dell

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Sivakumar Chandrasekaran
    Sivakumar Chandrasekaran
    Posted on Jun 28, 2016 at 11:02 AM
    0

    wow.. BO 6.5 Deski Reports 😊 I love deski reports because we can achieve any requirement with Macro.

    BO4.1 is a different product when you compare with BO 6.5. :-(

    As Dell mentioned, you can use SDK :-) you have to redesign(universe and corresponding dependent objects based on available new features in 4.1 ) if you don't want to use SDK/Macro again.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Denis Konovalov
    Denis Konovalov
    Posted on Jun 28, 2016 at 11:28 AM
    0

    what is the business requirement and the logic for this requirement ?
    who reads all those pdf's ?
    wouldn't it be easier for users to receive their docs in more interactive manner ?
    pdf's on file store are also not very secure solution.

    So, besides SDK and Publication alternatives - maybe a new approach to business need is also warranted.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.