Analysis of Production Reports and Universe

Posted on 2009-04-21
Last Modified: 2013-11-15
Hi All,

There is a change in the business rules, need to analyze how this change will be getting affected in the current production BO Deski, Webi reports and the BO universes.

For example, previous they were using table field called CODE to define the logic in the report variables and universes objects / filters. Say, If the first letter of the code is CODE=2 then X else Y; As per the new business rule, the total length of number got increased from 6 to 7 digits, and the new number first letter will start with 3.

So need to analyze this in the production universes (around 200) and reports (12000+) and to implement this new number logic where ever it is required in reports and universe.

Please let me know if you have any approach for analyzing the reports and universe and finally to generate list of reports and universes which need modifications.

Please let me know if you have any BO tools for this analysis.

Thanks in Advance.
Question by:reachsoma
    LVL 16

    Accepted Solution

    Any report that is based off a universe should not be affect because the universe acts a as a semantic layer where you can do all your changes without changing the report.

    From the reporting side there are a series of tools that you can look at.
    Under Crystal Report Documentation and Mass Edit/Analyze Reports.

    The universes maybe something like Data integrator by boe.. but they have so many products now that they dont show on their website it is hard to tell..
    LVL 1

    Assisted Solution

    One product I could recommend specifically for this purpose is System Profiler for BusinessObjects.  SP is a metadata analysis tool that extracts information from your BOE repository for reporting.  One of the canned reports included with the product is a Universe / Report relationship.  This report and the underlying data will allow you to perform impact analysis.  

    30-Day trial and other information can be found here:

    Hope this helps.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Suggested Solutions

    Title # Comments Views Activity
    web based reporting not a saas 9 55
    SSRS Expression 13 86
    Convert *.edb file to *.csv 4 163
    SSRS hide tablix 1 248
    Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
    From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now