Can there be a row level security on the objects that you are selecting from? Something not allowing that person to see the data. Or maybe they are not connected properly to company, or site, or some other configuration to give them access.

Which views are you trying to select from?

@ola.nissen Thank you for your pointers.

I have been through the debug and tried running each query in SQL logged in as my user and as ifsapp.

I have found that the following FACT_GL_BAL_SET_ANALYSIS returns data for IFSAPP but when I carry out a select on the same ZERO rows are returned.

The Information Source has Has Security Filter checked. and the FACT_GL_BAL_SET_ANALYS_DM has been granted to the permission set attached to my user.

Any ideas?

Thank you.

John 

 @johnw66 ,

Do you also have access from a functional point of view to the company/ companies used in the company.?

If you think it is a permission issue, and you have permissions granted to FACT_GL_BAL_SET_ANALYS_DM , I assumed you have already queried for data in the FACT_GL_BAL_SET_ANALYS_DM and have come across similar results?
 

@ola.nissen 

Ola, I have managed to resolve the issue by debugging the report and reviewing each of the SQL statements.  I narrowed down the issue to 2 FACT Information Sources that had the Has Security Filter checked.  By adding my user to the Information Source Full Access

Without checking any of the boxes in the section below.

The report then successfully ran and produced data when logged in as my user.

Regards

John

@Pradeep de Alwis  Thank you for your input.   Yes I ran SELECTS both as my user and IFSAPP,   

As IFSAPP multiple rows were returned whereas logged in as my user no rows were returned.

All resolved now.

Thank you  to both @Pradeep de Alwis  and @ola.nissen for you time and pointers.