BI Publisher datamodel on HCM
Hi,
I am working on BI Publisher. Need to create datamodel on HCM tables in BI Publisher. But getting the following error.
“You cannot create a link to a child group as it is having a Parent group”
Need to join datasets on HCM tables in BI Publisher. If I write SQL with these tables then it is fine but if we create datasets on these tables then it is causing error with one-many and many-one joins.
Could any one please help with this. Also please let me know where to find physical SQL of BI publisher reports. This needs to be done asap.