Count
570409Apr 2 2007 — edited Apr 9 2007I am experimenting with OLAP by trying to create a simple report that will count the number of records for a specific category. I have read all other posts dealing with count but have not been able to create a working example in AWM.
I have a relational table with two columns, category and attribute. For each category there can be multiple attributes. I want to count the number of attributes for each category.
In SQL it would be easy:
select category, count(*) from my_table group by category
How do I get the same results from olap? I am using oracle 10g and the analytic workspace manager.
Thank you!