Key Figures not showing in BEx Workbooks

[Former Member]

Hi,

Recently we migrated the BW3.5 workbooks to BI7. After the migration and transportation of the workbooks to Quality system, in some of the workbooks the Key figures are not showing up and in some workbooks the key figures which are set as 'Hide" in the query are also showing up.

Can anyone please suggest a way to fix this issue.

Thanks in advance.

Kalyan

[Former Member]

That means your transaction data is not being retreived check with the infosource of the transaction data.

Look if you are getting same error for all the reports if yes then look at the transaction data. I dont know why is it saying hidden...May be the migration of Infoobject key figures didnt happen properly into BI system. Check that Key figure migration in the Modelling system. Give me more information probably we can analyse on that

[Former Member]

Hi,

Thanks for your response.

Even if there is no transaction data for the key figure, it should still show up in the report but as blank column, but in my case the key figure is not at all showing in the report.

"Hide" setting for key figure is specific only to BEx and is done in the BEx query, which is being used by the Workbooks, so i do not think that it has anything to do with the InfoObject migration.

Kalyan

[Former Member]

You didnt answer if you are facing this problem with all your reports or only few reports ..Also check if it is from all the cubes or particular infoproviders ..do update