I transported a role, which in turn resulted in worksbooks that were created in Production, to be lost.
The workbooks and associated queries were created (by prev. team member) in Production and I was wondering the following:
1) Will the queries still be in Production, even though the workbook is no longer visible? Seems like they are.
2) Are the workbooks still there, only that the link to the role is broken? And is it possible to retrieve the workbooks somehow? (Unfortunately I do not have an excel copy of them). Someone on the forum made mention that they republished the workbook via PFCP...but how??
3) Is it good practice to create workbooks straight in Prod? I have read a few articles and it seems that queries should be done in dev and transported, but no mention was made about workbooks. I would think that the same rule should apply?
Any assistance will be greatly appreciated.