This discussion is archived
0 Replies Latest reply: Jun 4, 2012 2:53 AM by 536120 RSS

Text file imported into Hyperion report BQY

536120 Newbie
Currently Being Moderated
Hi,

I would like to know the internal process how Hyperion works in the scenario
1. The Hyperion report query in select * from emp
2. A text file containing list of emp ids has been imported into the report bqy

I believe the query which gets fired on the underlying database is still select * from emp. If so, is it true that the result set of the "select * from emp" then is filtered in the Hyperion server memory based on the emp ids listed in the text file which is embedded in teh report bqy?

I am using Hyperion 9.3.0.

Any input would be appreciated.

Regards,
Suresh

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points