US and Worldwide: +1 (866) 660-7555
Results 1 to 4 of 4

Thread: Views in Schema Workbench.

  1. #1
    Join Date
    Oct 2012
    Posts
    102

    Post Views in Schema Workbench.

    Hi Team,

    I want to desgin a cube using Mondrian Schema Workbench.

    But i want to use 'Views' instead of 'Tables'. Is this possible? Can i use views instead of tables for buiding the cube?

    Please let me know. Thank you.

    Regards,
    Naseer.

  2. #2
    Join Date
    Jan 2013
    Posts
    11

    Default

    Hi,

    In general, using a SQL query as the fact "table" does not perform well.
    You can get around this by creating a view in the database itself and using that as the fact table.

  3. #3

    Default

    Just use them. Yes, it is possible.

  4. #4
    Join Date
    Oct 2013
    Posts
    18

    Default

    Would you tell me how did you get it?
    I have inserted the sql view code at Cdata space, but I don't know how to find the column to define a measure.

    Thanks in advance.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •