syntel Posted July 16, 2009 Share Posted July 16, 2009 Hi, For any dabase operation, we can treat views similar to tables.Hence, can you please confirm whether database views instead of tables can be used for Analysis Report. Link to comment Share on other sites More sharing options...
tkavanagh Posted July 17, 2009 Share Posted July 17, 2009 Views should work fine. Link to comment Share on other sites More sharing options...
syntel Posted July 17, 2009 Author Share Posted July 17, 2009 Thats true, I did generated Analysis Report as the final output using Views.But the my current problem is, I am unable to generate mondrian.xml using Views via Workbench, According to the first snapshot I am not getting any view name from the DB using workbench. All I get is a column called alias. According to the second snapshot I am able to see the list of the tables from the DB using workbenchBut , I did generated my mondrian.xml using Views via CubeDesigner. But my development envronment is suppose to be workbench .Hence my qusetion is using Workbench, like I can see the list of tables, is there any way that I can see the list of of database views?Note - I am currently working with Workbench-3.5.4 & postgresql.Just now I noticed that views are also getting listed along with tables. However, let me verify it again.Post Edited by syntel at 07/17/2009 12:27 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