Skip to Content

Hello Folks,

Instance Management in BusinessObjects is the topic of discussion for this blog. Let us see more in detail about reports and program objects Instance management further.

Instance is an entity which is created whenever a report or a program objects is scheduled to run. Up on creation these instances are stored in Output File Repository. To get the right information as on when required, it is always important managing and backup those reports and instances as they contain organizational data.

Instance management plan enables us to

     –  Identify scheduled reports and their frequency of schedule
     –  Retention period till which instances need to be maintained
     –  Size of each report instance and the amount of disk space required
     –  Necessity to keep organizational sensitive data (Instance cleanup)
     –  Schedule destinations

We can manage instances by setting instance limits at below levels

  • Global limits (If it is required to set the limit throughout all the public folders and sub folders, we need set it at global level. We need to turn on inheritance to cascade the settings to sub folders and the objects.
  • Folder limits (This will help us to set the limits for all the objects contained within the folder)
  • Object limits (Applying limits to specific object then we need to set it at object level. This will override the limit set at folder level.

                    /wp-content/uploads/2013/04/limits_201097.jpg

                         Untitled.jpg

And based on below criteria’s

  • Number of Instances

                    This will enable us delete excess instances when there are more than N instances of the object.

  • User/User group

                    This will help us to set the limits per user/user group on a particular object.

  • Number of Days

                    This will enable us delete excess instances when the age of the instance exceeds N days.

               /wp-content/uploads/2013/04/2_201116.jpg

Key benefits

     – Reduced File Repository Store backup size. This is a huge benefit as this backup is taken on daily basis.
     – User need not search for a huge list of instances.
     – By controlling the number of instances we can minimize the amount of space required in Output File Store

Hope this blog is informative. Thanks for reading!

To report this post you need to login first.

39 Comments

You must be Logged on to comment or reply to a post.

  1. Masood Aftab

    Hi Mani,

    Thanks for the information. Can you please let us know if we need to restart any service after setting the limit. I have set the limit on global level but its not working.

    Regards

    Masood

    (0) 
    1. Rahul Verma

      Hi Masood,

      There is no need to restart any services. It should start working 4am everyday (default time).  Are you still facing any issues?

      (0) 
    1. Rahul Verma

      Hi Patrick,

      It will count both failed and successful instances.  The limit being applied is on the instances, regardless of failed or successful.

      It simply wipes out the excess history until it reaches the limit set.  By 4am, which is the default time, the instance clean-up will initiate.

      (0) 
    1. Rahul Verma

      Hi Teresa,

      By making sure you have the first option ticked i.e. “Inherit From Parent Folder” will answer your query.

      To get to Assign Security, In CMC, you right click the sub folder and it will list all available options- you select User Security, then select Principal (the user or user group) and select Assign Security- then you reach the option whether to or not inherit from the parent folder.

      Inherit_from_Parent_Folder.JPG

      So now lets say if you set Instance limits on All folders (the parent- top folder), and there are sub folders within it, say there is a sub folder called Test_Folder (child) under All folders, then on Test_Folder, you can simply follow the steps and the screenshot as I have mentioned, whether to or not enable the folder inheritance.

      (0) 
      1. Teresa Noguero

        Thanks Rahul for your answer.

        The problem we have is that subfolders have different security access than the parent, so for example the top folder is accessible by everyone, but some subfolders have some restrictions because they information they have. In order to create different access level we unselect the flags you mentioned. Does this mean that you can not use cascade limit if your children have different security requirements? as far as I can see the flag is used in both cases: security and limit.

        If that is the case and we have some subfolder with not inheritance, will the cascade limit still work for the rest of subfolders or will it be broken globally. 

        Thanks in advance,

        Teresa

        (0) 
        1. Rahul Verma

          You are right Teresa.

          As Inherit from parent folder is the only option to flow down the settings to the child folder from parent; so in your case – you’ll have to explicitly right click the folder concerned, click Limits, and set the desired instance rule on those select folders.  This will be a tailor-made solution in your case.

          (0) 
    1. Rahul Verma

      Hi Shalini,

      Could you please give some more clarity on how are you setting the limit on number of reports per user using Instance Manager?

      Did you mean manually deleting instances from Instance Manager?

      (0) 
      1. Shalini Kyanam

        Hi Rahul, Sorry for the delay in reply. We have a non-functional requirement from the customer that user should not create more than 100 reports. I’m not sure if it is possible through instance manager.

        (0) 
        1. Rahul Verma

          Restricting user by having him/her to NOT create N number of reports is not possible anywhere in BO.  If you meant, that the user should not create more than N instances of a report then this is possible only through limits (if you want it automatically) and not through instance manager – unless you want to manually do it in Instance Manager by deleting selectively.

          Thank you, Rahul

          (0) 
  2. Zakaria MIMOUNI

    Hi Rahul,

    Do you know where you can set the time when server cleans the excess of instances ?

    You mentioned 4 am as a default time, i would like to modify it.

    Thanks

    (0) 
    1. Rahul Verma

      Hi Zakaria,

      At the moment, I am several days away from server but its in the registry,and from what I remember

      HKEY_LOCAL_MACHINE\SOFTWARE\SAP BusinessObjects\ Suite XI 4.0

      but if you search near this, you will get the paramter.

      You will also find the batch size and other settings.

      Let me know if it helps.

      (0) 
  3. Monish Patel

    Hi Mani, Everyone,

    Thanks for the wonderful blog.

    1) Does this limit apply to the “Recurring” Instances as well ?

    2) What type of instances are applicable while applying the limits (Success, Failed, Pending, Paused, Recurring) ?

    3) When we keep the limit to N, it means the LATEST N will be retained, isnt it ? the OLDER instances will be deleted, isnt it ?

    Regards,

    Monish

    (0) 
  4. vizit yadav

    Hi Mani,

    I have a requirement, In Public folder, every user should only see instances of reports scheduled by themselves but not by others.

    Is this type of access is possible in public folders.?

    Please help.

    Thanks
    Vizit

    (0) 
  5. Hans-Peter Petzoldt

    Hi Mani,
    hi all others,

    I’m struggeling with the folder limits and access right to amend them.
    Is it possible to deny the amendment of limits which are set by Administrator ?
    The goal is to set a “master” limit which can’t be changed by others.

    Regards,
    Hans-Peter

    (0) 
  6. Raj Patel

    Hi

    We use BO 4.1 at my work.

    We have around 600 instances of reports running in BO production server.
    All of these reports have one username/password combination.

    Now, we have a need to change the database connection/password to something other than the existing one.

    Is there a global place where i can change the password and that will get updated in all the scheduled runs or do i need to go to each and every instance and manually change the password?

    Thanks

    Raj

    (0) 
  7. Raj Patel

    Hi

    I’m back again with one more question 🙂

    Is there any way to export “details of BO instances” (paused, recurring, success, failed, pending, running) in to Excel or csv file using BO CMC?

     

     

    Thanks

    Raj

    (0) 
  8. Raj Patel

    Hi Mani,

    Thanks for providing the solution for changing db connection/username/pwd for BO recurring runs.

    My bad, we use same username/pwd to schedule all recurring runs.

    It is the Database Server which we change during each upgrade of our Application. (e.g ARG7P2 to ARG8P2).

    During our last upgrade we ended up changing this server name for every single scheduled recurring.

    Raj

    (0) 
  9. aravind atluri

    Hi Mani

    Some of the reports have instances (see the below pic) for years and now the Business users wants to archive/save these instances to a shared drive. Is there any option in CMC to save these instance files to a shared drive or do we need to write a custom program, please let me know.

    Thanks,

    Aravind

    (0) 
      1. aravind atluri

        Hi Mani,

        Yes, its a business requirement to keep the instances for a certain period of time for some of the report.  now they want to archive these to a separate (shared drive) folders by date.

         

        Thanks,

        Aravind

        (0) 
  10. Thomas Buxereau

    Hi there

    I have deleted old instances of reports but the physical files are not removed from the filestore server. I deletd them by changing the limits on the folders. Is there another cleanup process required?
    Do I need to restart the server??

    If I delete the report, it and its instances disappear from the BO Server and the filestore, however if I set the instance limits the instances disappear from the BO system but not from the filestore? The reason for setting the limits is to make space on the server but it’s not helping.

    We are using BO 4.1 SP5.

    Thanks

     

    (0) 

Leave a Reply