OTBI report gives an error when add Workforce Management - Person Real time subject

Mirza_Adeel

Dear ,

I have an OTBI report which works fine on subject Workforce Management - Worker assignment Real time

but i need two more column which is in Workforce Management - Person Real time subject when i add this subject report gives an error  

(None of the fact tables are compatible with the query request Fact - Person.Person Extra Information_PER_PERSON_EIT_EFF_Tribe__and__Squad__Details_squad)

please guide me how to resolve this.

Thanks

Bhaskar Konar

Hi @Mirza_Adeel ,

You need to choose a Measure column from Each subject area as well as attributes from each subject area. You can hide those columns that you don't need but it should be in the list of columns.

Let me know how it goes, alternatively add your report catalog or xml so that it can be looked.

Hope this help.

Cheers,

Mirza_Adeel

Dear ,

Report xml is loaded

xml.txt

Bhaskar Konar

Thank you, I'll keep you posted @Mirza_Adeel

Cheers,

Bhaskar Konar

Hi @Mirza_Adeel ,

Can you please check the attached XML?

Hope this help.

Cheers,

xml_Person_Assignment_SAs 180422.txt

Mirza_Adeel

Dear ,

Thanks alot its running now. Could you please guide me what you do? so i can do it myself on test environment

Thanks

Bhaskar Konar

Hi @Mirza_Adeel ,

Glad it worked for you.

As I told you in my previous post that measure column needs to be selected from both Subject Areas. I have found that you have selected 'Headcount' from Assignment SA but there was no Measure got selected from Person SA.

So I have just selected 'Person Count' from Person SA and hide it.

Please let me know if you need any more information.

Hope this help.

Cheers,

Mirza_Adeel

Dear ,

Can you please guide me its working but now i am checking its give an error

i have attached your give xml

please check

xml_Person_Assignment_SAs 180422.txt

Mirza_Adeel

Dear ,

Bhaskar Konar its working fine before 2 days but now its give an error we did not do any changes report is not running can you please guide us?

xml_Person_Assignment_SAs 180422.txt

i attached your given xml

Bhaskar Konar

Hi @Mirza Adeel ,

Can you please share the error details like error message and entire error text etc.?

Is there any changes for the Report that is throwing error?

Cheers,