This discussion is archived
1 Reply Latest reply: Dec 13, 2012 4:47 AM by Srini VEERAVALLI RSS

Need Usage Pattern Report in OBIEE 11g

746675 Newbie
Currently Being Moderated
Hi All,

I have a requirement, where I need to know who logged in, to OBI Application in the last 3 months and who has not. How do I get that? Basing on START_DT in S_NQ_QCCT, I can put a filter with Start Date using BETWEEN RANGE, but since OBIEE logs in only those users who logs in, am not sure how to capture the records for non-logged in users during the same period. I have to report output in a pie chart with the percentages.

Any help would be highly appreciated, since its an urgent need. Thanks in advance.

Regards,
Vinag

Legend

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