Skip to Content

BEx queries (3.X) saved in Query Designer 7 , still has the old 3.X layout in PFCG

Hi,

Problem Description: BEx queries (3.X) saved in Query Designer 7 , still has the old 3.X layout in PFCG.

We are in the middle of migrating BEX 3.X query to BEX 7,

In the current situation, we have an existing roles that has BEx queries (3.X) published to it, using PFCG.

For example:

Role: YBW_MENU1

- Report_1

*All reports are 3.X reports

When we open Query Designer 7 and save the Report_1 (now it will be saved as BEX 7 report),

and publish it again (to the original location as the 3.X was ) we expect to see
the new report in PFCG , but we don't.

PFCG shows the old 3.X report!

Just when we deleted the old report and publish the new report ... only then we will
see the new report.

Problem is : we have hundreds of reports...so do it manually, it will take a lot of
time.

Is there any "Automatic" way to remove the old one and show the new one instead?

Thanks in advance,

Morchi

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on May 30, 2013 at 06:56 AM

    I don't think any automation is available to change all the old queries to new queries in the roles. You can migrate the old roles to new roles, but the query assignments have to be done manually it seems.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 30, 2013 at 01:38 PM

    Hi Morchi,

    Unfortunately there is no automated process.

    Regards,

    Arvind

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 31, 2013 at 02:19 AM

    Hi Morchi,

    As above said there is no automation process, but as per my understanding we have to save manually all the reports under role. Later check that role whether correct reports are assigned and transport to further, so what i suggest

    1. Delete all workbooks from existing roles in a single go from PFCG.

    2. Hope you have access to the existing role, otherwise get it for your ID.

    3. Anyway you have to save once you migrate from 3.X to 7.X, so save directly to existing role.

    I feel these steps are easy, correct me if I'm wrong.

    If you have many roles, then ask basis/security team to copy the folders/reports from existing to others. Even we followed these steps.

    hope it helps,

    Umashankar

    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.