Home » Developer & Programmer » Reports & Discoverer » A question on date hierarchy for Oracle Discoverer
A question on date hierarchy for Oracle Discoverer [message #88770] Tue, 11 March 2003 10:53
Xuewei
Messages: 1
Registered: March 2003
Junior Member
A question on date hierarchy for Oracle Discoverer

I am using Oracle Discoverer Administrator 9i and Discoverer Desktop9i. I have a question on data hierarchies. For example, I created a date hierarchy: YYYY, QQ, MON, DD. Then, I applied the date hierarchy to a data item (OpenDate). The Discoverer will automatically creates all the data items that are required to complete the date hierarchy. In this case, we will have OpenDate, OpenDate YYYY, OpenDate QQ, OpenDate MON, and OpenDate DD. When the users use Discoverer Desktop to create queries, they will see all those five date fields.
My question is: How can I only show one date filed (such as OpenDate YYYY) to the user in Discoverer Desktop, and still can let the user have the ability to drill down on that date filed?

Thanks

Xuewei
Previous Topic: printing footer except last page
Next Topic: Writing a break matrix report to csv file
Goto Forum:
  


Current Time: Fri Mar 29 00:38:55 CDT 2024