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.
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.
Have you tried:
select * from FACT_INVENT_TRANS_HIST_DM
Have you tried:
select * from FACT_INVENT_TRANS_HIST_DM
That would work! 
+9
Hi
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
appreciate your input.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
