US and Worldwide: +1 (866) 660-7555

Search Forums:

Type: Posts; User: rin397; Keyword(s):

Search Forums: Search took 0.00 seconds.

  1. Replies
    4
    Views
    873

    hey, all, The exception still not solve. ...

    hey, all,

    The exception still not solve.

    But I take the SQL to Workbench for MDX Query.


    The SQL work on Workbench MDX Query,but not work on the olap.

    what's else I should to try?
  2. How could I let one schema file include other schema?

    We have 5-6 Systems, and each system let different member to maintain.

    So I want create schema files for each systems' member to maintain , but parts of dimension are the same in these system.
    ...
  3. Cos the DB is oracle 10g, we add a virtual column...

    Cos the DB is oracle 10g, we add a virtual column for composite key.
    it's work now.
  4. Replies
    4
    Views
    873

    Thanks mcampbell your reply. My fact table's...

    Thanks mcampbell your reply.

    My fact table's column - start_date its type is Date and format is yyyy/mm/dd,
    and the time dimension's column - FULL_DATE its type is Date and format is...
  5. Replies
    4
    Views
    873

    Time dimension column type Date in oracle

    hey, All,
    At first , My db is Orcale.
    A column type is String and its format (YYYYMM) in time dimension and fact table.
    it's work.

    But A column type is Date(ex: 2008/1/1) in time dimension and...
  6. Thanks your reply, I will modify the table...

    Thanks your reply, I will modify the table structure.
  7. How to solve if dimension table has composite key.

    I google some information about the composite ,but I can't find solution.

    Anyone could give some keyword or example?

    Example
    Dimension table1


    account_id
    customer_id
  8. Thanks mcampbell your reply let me find solution....

    Thanks mcampbell your reply let me find solution.

    I try NON EMPTY to solve my problem.
  9. In My situation how to design the schema.xml

    Sorry, I have no idea how to design schema.xml base my situation.

    I have three dimension table

    Account


    accountID
    AccountName
Results 1 to 9 of 9