Analysis for Office insert Datasource dialog only shows queries. InfoProviders not showing.

[sap_cohort]

In my Quality System I am getting an AO Report Error that the DataSource is not found.

I create an AO Report in DEV over a CDS View Transient Provider of type DIMENSION. 
This is done by opening up a blank workbook and doing a search and insert for the DIMENSION Provider.  This works great.

In my Dev System:
Creating a new AO Report by searching and inserting a DataSource shows both Queries and Providers available for selection.

In my Quality and Production System:
Creating a new AO Report by searching and inserting a DataSource shows only Queries available for selection. 
No providers are showing up at all for selection as I do in my Dev system.  
I verified that the Transient Provider is available in Quality system using transaction RSRTS_ODP_DIS. 

Would anyone know what or where I should spend my time figuring out why I only see Queries and not Providers in Quality?  

Thanks for any input on this issue.   

[FernandoPerezMerino]

You could test your authorizations in QUA & PRD systems. 

Run Tx SU53 to test if you have permissions to get data in those systems.

You need S_RS_ODP with ABAP_CDS & S_RS_ICUBE for the transient provider.

Probably this is the problem, then you have to implement auth like this example:

ODP Context = ABAP_CDS
ODP Name = *
Activity = 03 / 16

Ahother way is to execute Tx RSADMIN in DEV you will have RSBOLAPSHOWINFOPROV & RSBOLAPSHOWTP parameters with "X" and probably in QUA & PRD not.

[robert-31]

Tnks buddy i was looking for this one.

[sap_cohort · Accepted solution]

I found the issue:
RSADMIN Table setting DFT_QUERY_CDS_SUPPORTED was configured in DS4 for testing, but not QS4.

SAP no longer fully supports the generation of default queries over data providers CUBE/DIMENSION.
2745251 - SAP S/4HANA: Deactivation of standard queries for Virtual Data Model InfoProviders

Solution is to just build an Analytical Query over the Dimension CDS View and report from that. 
SAP made this change not to utilize "Default Queries" due to potential data access issues where users are exposed to all fields of the provider instead of the explicit fields of an Analytical Query.  

Hope this helps the cause.  Thanks for the help.