suppachartt Posted July 3, 2009 Share Posted July 3, 2009 Hi everyone,I have a view table that has already been aggregated (AGG_CUBEVIEW).Is there is a way that I can tread this table as a fact table and bypassing that aggregator attribute in <Measure>?Regards,SuppachartCode:<Schema name="ABC"> <Cube name="Cubes"> <Table name="AGG_CUBEVIEW" /> ... ... ... <Measure name="Agg Sum" column="AGG_SUM" aggregator="sum" /> </Cube></Schema> Link to comment Share on other sites More sharing options...
swood Posted July 6, 2009 Share Posted July 6, 2009 Hi Suppachart, Look into using aggregate "tables", which in your case is your materialized views. In your schema, there are aggregate sub elements under the main fact table of a cube that can be set to define a series of aggregate tables, their attributes etc. ShermanJaspersoft Link to comment Share on other sites More sharing options...
suppachartt Posted July 7, 2009 Author Share Posted July 7, 2009 But in my case the Aggregate table is fact table. Link to comment Share on other sites More sharing options...
swood Posted July 22, 2009 Share Posted July 22, 2009 The OLAP engine will not care that it is a view in Oracle. If you can "select * from view", you can use it as the "table" in this case. ShermanJaspersoft Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now