Skip to main content

Community,

 

I have all information sources ready (using criteria filter), plus the permission set. but when I run business reporter against the information source, it returns nothing at all. to be best of knowledge, there could be no data in the information source.

question here, what is the best way to query for the data in Information Source, just SQL do a query?

 

Thank you.

Yes. An information source is “no more” than a view, from a database perspective. So you can query for it with SQL to validate it. Make sure to be logged in with the same user as the one that you are logged in as when running through BR - it could potentially be that there is row level security set up, meaning that the user don’t see the data although it’s there in the database.

@ola.nissen Thank you for your input.

Can you advise how to query it? for example, FACT_INVENT_TRANS_HIST this source

and it can be queried under SQL Tool window?

what is the syntax then?

 

Thank you.

 

@ronhu 

Have you tried:  

select * from FACT_INVENT_TRANS_HIST_DM 

 

@ronhu

Have you tried:  

select * from FACT_INVENT_TRANS_HIST_DM 

 

That would work! :thumbsup:

 

Hi @ronhu,

 

By enabling the "Display data access details" checkbox you can find the available view names for online and DataMart methods.

 

And you can query data from the available views.

 

Example : Select * from FACT_GL_BALANCE_OL

              Select * from FACT_GL_BALANCE_DM

 

Best Regards,

Thiwanka

@ola.nissen 

@Thiwanka Sandaruwan 

@RutJWhalen 

appreciate your input.

Terms & ConditionsCookie settings