cancel
Showing results for 
Search instead for 
Did you mean: 

Query not opening after transport

Former Member
0 Kudos

Hi All,

I transported Query to production but it is not open in production.But same query is working fine in Dev and QA.In Prduction it is givng eror like this.

Diagnosis

InfoProvider ICSALES does not contain characteristic ZBPTEST. The exception aggregation for key figure ZBP_CNTSUMCNT can therefore not be applied.

System Response

The key figure will therefore be aggregated using all characteristics of ICSALES with the generic aggregation SUM.

Diagnosis

Characteristic Industry (Revenue co was not found in InfoProvider .

Procedure

Before you can delete an InfoObject from an InfoProvider, you must change all the queries that use this InfoObject. Therefore you have to delete the relevant InfoObject from these queries.

Query is still using an InfoObject like this.

System Response

Procedure

To change the query, put the InfoObject back in the InfoCube, adjust the query and then remove the InfoObject from the query again.

Procedure for System Administration

But INdustry Object is there in Cube.

HOw can i solve this problem.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

k,closed issue

Former Member
0 Kudos

Ok,

If i helped then please assign points.

Diogo.

Former Member
0 Kudos

Hello chang bw,

for your error status:

Diagnosis

InfoProvider ICSALES does not contain characteristic ZBPTEST. The exception aggregation for key figure ZBP_CNTSUMCNT can therefore not be applied.

This InfoProvider ICSALES has a characteristic called ZBPTEST in DEV and QA but it's not in PROD that's why the system is complaining.

Compare the InfoCube between PROD and QA and DEV and make the necessary adjustments to the InfoCube in PROD (by transport) to be like the InfoCube in QA and DEV.

Then retransport your query again. It should be working just like QA and DEV again.

Please assign points,

Diogo.