cancel
Showing results for 
Search instead for 
Did you mean: 

BO4 - existing reports not picking up new sql

former_member272336
Participant
0 Kudos

Hi,

We have existing WEBI reports and they are using old sql for the objects.

The universe definitions have since changed.

Why is this?

How can we resolve.  Using BO4 SP6.

In older version when made change was picked up automatically such that existing reports would run the new sql.

Thanks

Philip

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Phil,

Do you see any issue with existing universes after upgrading to Sp6 or is it more specific to a publihsed universe not reflecting the SQL changes you perform at data foundation or Business Layer.

Please give some more details so that someone can be spot on with their solution or work around

Thanks

Mallik

Former Member
0 Kudos

Hi Philip,

Agreeing with Mallik, a bit more details could be useful.

Are you possibly experiencing what is described in KBA 1689168 or 1803579?

Does the SQL gets properly generated when you change the data source in Web Intelligence and re-point to the same universe?

Best regards,

Victor

former_member272336
Participant
0 Kudos

Hi  All,

Thanks for replies.

Here is example.

Change in object definition sql in the business layer e.g before said sum(mesaure)

Change the definition to sum(measure+1).

Publish busines layer to repository.

If open existing report  still shows sql as sum(measure).

If repoint to same universe picks up correct new sql (i.e sum(measure+1).

Using bo4 sp6.

Believe auto_update_query set to Yes on both business layer and data foundation layer but stil unless explictly reset takes old parameter.

Will need to check the adaptive rpocessing server retstarted as per sap note 1689168 in your post.

Thanks

Philip

 

Former Member
0 Kudos

Hi Phil,

Can you retrieve published copy of universe from repository and  check if Business Layer properties>Parameters and Data Foundation properties>Parameters share the screenshots of  the same, just to confirm, both layers have auto_update_query set to Yes.

If the settings are set to Yes, then try making some change in Universe object SQL on the retrieved universe, save Business Layer, Publish it and try to create a new webi report on the published universe to see if changes are reflected.

If the above test is successful with new webi report , then try with an existing webi report from Launchpad and it should work since its reflecting in new report already.

Thanks

Mallik

former_member272336
Participant
0 Kudos

Hi Mallik,

Thanks for advice.

Will check this out.

Philip

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Philip,

In Query panel just remove the changed object (whose definition is changed) and add it again then check the sql of the query there you will see that modified object sql will be shown and then run your report -> save it -> export to repository.

By this way you can get the latest sql for your report.

Thanks,

Suresh Babu Aluri.

former_member272336
Participant
0 Kudos

Thanks Suresh

former_member182521
Active Contributor
0 Kudos

Hello Philip,

Could you please clarify whether you changed Universe definition or objects definition. If you changed objects definition please ensure whether you have exported with modified Business layer to repository.

As long as the modified object is not deleted and recreated it should work fine.

Regards,

Mani