Thank you, Mandeep. Agreed with you. Your reply is to the point. We finally created 3 custom roles. 1. XXXXXX BI Administrator role ( Meant for IT folks ). 2. XXXXXX Business Reports Developer - which just inherits BI Author ( Meant for end Business users. Goes along with their Duty roles which carries related OTBI…

Thank you, Ilyas. Want clarify further: A user with only role "BI Author Role" can create an analysis etc but not a data model. A report must have a data model. Therefore an author cannot create a report other than a report on a data model that someone else has created. An author user who also has "BI Publisher Data Model…

We know "BI Author" role will give both functionality - Ability to create Report and Analysis OTBI Reports. But I want to give end users ability just to create "Analysis OTBI Reports" and keep them away from complex BI Reports creation.