Analysis Report on database Views

0

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.

syntel's picture
11
Joined: Jul 9 2009 - 7:10am
Last seen: 10 years 2 months ago

2 Answers:

0

Views should work fine.

tkavanagh's picture
3163
Joined: Jul 7 2006 - 8:54am
Last seen: 5 years 2 weeks ago
0

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 workbench

But , 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
syntel's picture
11
Joined: Jul 9 2009 - 7:10am
Last seen: 10 years 2 months ago
Feedback
randomness