#Syntax error for all measure columns in webi report in UAT

[Former Member]

Hi experts,

I'm facing critical issue in my QA webi reports.

When i moved the reprots from DEV to QA and when i tried to execute the QA reports am getting all measure columns are #syntax errors and my users are not able to do their testing.

I created new report in QA and am able to see all measure columns are populating with out any errors.

we are running SAP BO 4.1 SP4 and reports are running on BICS

Kindly help me in this regard.

Thanks & Regards,

Kumar V

[arijit_das · Accepted solution]

those columns are direct objects from the query or any formula ?

[Former Member · Accepted solution]

Hi Arjit,

All the columns are coming query but i applied some alerts on totals.

But the reports are running fine in DEV with out any issues.

Thanks & Regards,

Kumar V

[Former Member · Accepted solution]

Hi Experts,

Kindly help me out to get rid of #SYNTAX error in webi report for all the measure columns.

Thanks & Regards,

Kumar V

[Former Member · Accepted solution]

Hi Arijit,

Please guide me What is the solution in order to solve this issue.

Thanks & Regards,

Kumar V

[arijit_das · Accepted solution]

#SYNTAX occurs when a formula references an object that no longer exists in the report. Make sure the report has been moved correctly without error. If you go to edit query, do you see any error(like some object no longer exist) ?

[Former Member · Accepted solution]

Hi Arijit,

Many thanks for the response.

Yes ,when i saw edit query all measure columns got disappeared.

Thanks & Regards,

Kumar V

[arijit_das · Accepted solution]

That means, the underlying layer is not migrated properly. Are you creating webi on top of universe or BEx ?

In case of universe, make sure the universe is also migrated along with the webi. It may be the case that the objects in development system have different Object IDs than the same in production system. So, better to move universe also along with webi.

In case of BEx, make sure you have development and production BW are in synch. Instead of creating objects separately in two systems, it is recommended that you create in development and transport to production.

[Former Member · Accepted solution]

Hi Arijit,

All my BOBJ reports developed on top of BeX Query.

I checked with my BW consultant and he confirmed all transports moved correctly from DEV to QA.

Once the BW things got migrated to QA then i moved the BO reports to QA ,and when i run the reports in QA am getting #SYNTAX error all the measure columns only and all measure objects got disappeared in Edit query.

Monday and Tuesday reports are working fine in QA .

from Wednesday on wards we are getting this issue.

I made some changes to BO reports and Yesterday again i moved my BO report to QA but still the issue exists. when i ask my BW consultant to move his transports again from DEV to QA he said both systems are identical.

Thanks & Regards,

Kumar V

[arijit_das · Accepted solution]

Is your OLAP connection pointing to right BEx in right system ?

To cross-check if the objects in both environment are in synch or not, follow the steps:

In BW dev, open the BEx in query designer. Take a key figure that is not appearing in webi quality.

Under extended tab, note the Enterprise ID:

Now, open the same BEx from QA and cross check if the ID is same or different.

[Former Member · Accepted solution]

Hi Arijit,

We cross checked all key figure columns from BW Dev and BW QA and all are not same.

I assume it's because of transports are not moved correctly from DEV to QA?

Do we need move again taransports from DEV to QA.

Thank you so much for your time and responses.

Thanks & Regards,

Kumar V

[arijit_das · Accepted solution]

It may occur if the objects are deleted from BEx in QA and created again. If you transport them, the ID will be same across all systems. If it is not same, the migrated webi will not recognize the objects in new environment and remove them from the query resulting #SYNTAX error in report.

[Former Member · Accepted solution]

Hi Arijit,

We see objects got deleted only when i migrate the BOBJ reports to QA and in edit query of the reports.

But in BW all the keyfigures are working fine.

Thanks & Regards,

Kumar V

[arijit_das · Accepted solution]

In BO, objects are mapped using unique ID. If the object ID is changed, webi will not be able to find it and remove those objects from query. In BW, it will work fine. But when you are building webi on top of BEx, it is necessary to synch BEx across dev, qa and production.

[Former Member · Accepted solution]

Hi Arijit,

Can you please advise me the approach to follow next steps.

We rasied the issue with SAP and we got reply from SAP as below

The #SYNTAX error occur when a formula references an object that no

longer exists in the reports or if you merged object based on a

hierarchy you cannot be used directly in the report. This is because

where the original hierarchy has a conflicting hierarchy structure,

the system cannot build a merge hierarchy. The system prevents you

from dragging the merge object. If the user builds a formula using the

merged objects the system return #SYNTAX.

But before you can try to enable the option #Extend merged dimension

values# in your Properties of your report.

Attached SAP Notes (1998427, 1958927) about this issue, please read

through them and see if they can solve your issue:

1998427 - Error #Syntax on merged dimensions using BICS connection in

web intelligence document

1958927 - Web Intelligence document that has report variables when

migrated from one environment to another, these variable appear

  missing in the destination environment

Thanks & Regards,

Kumar V

[arijit_das · Accepted solution]

I believe, you have understood the reason of the issue. So no need to contact SAP support for this. If you synch your BW dev and QA, this issue will be resolved. In future, do not modify/create/delete any object directly in QA BEx. Always test it in development and then transport to production so that the object ID is consistent across all environments.

[Former Member · Accepted solution]

Hi Arijit,

Sorry about that.

Many thanks for all your responses.

Once we are done with transports with BW and BO will update to you.

Once again thank you so much.

Thanks & Regards,

Kumar V

[Former Member · Accepted solution]

Hi Arijit,

My BW Consultant saying that enterprise will change when we move transports from BE DEV to QA

Can you share if you have any information on this it would really helpful for my issue in BO reports.

More over my BW consultant has deleted the Queris in BW QA and again he was trying to move the transports from BW DEV to BW QA but he is not able to move his transports.

we raised the SCN thread on this

http://scn.sap.com/thread/3664612

[arijit_das · Accepted solution]

The enterprise ID of key figures should not change after transport of BEx query.

If you want to be sure, post this question in forum.

[Former Member · Accepted solution]

Hi Arijit,

Many thanks for your advise and your suggestions.

Thanks & Regards,

Kumar V