Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ThorstenB

    one-to-many relations between fact table and dimension table

    This is only a simple example. We have a fix DB model and we cannot modifier it. We also cannot use distict count because we creating a local cube. Is there no other way?
  2. ThorstenB

    one-to-many relations between fact table and dimension table

    Hi, we have a problem with "one-to-many relations between fact table and dimension table". Take the example of table "LOGGEDFLAW" which is related one-to-many to the table "LOGGEDREASON. "LOGGEDFLAW" includes the column "FLAWKEY" and "LOGGEDREASON" includes the column "REASONKEY" and...
  3. ThorstenB

    Handle 1:n relations

    Hi, I build a local cube from a relation database. In the database there are 1:n relations. Is there a way to handle 1:n relations? For example: I have a table LOGGEDFLAW and a table LOGGEDREASON with a 1:n relation between them. We create a select statement of these tables and as an result we...
  4. ThorstenB

    Virtual Cubes

    Is there no way to handle 1:n relations?
  5. ThorstenB

    Virtual Cubes

    Sorry, distinct count is not supported in local cubes. But I need s.t. like distinct count and distinct sum.
  6. ThorstenB

    Virtual Cubes

    I dont know if virtual cubes are the correct method of resolution. What I need is to handle 1:n relations in a Cube. Here a little example: I have a table LOGGEDFLAW and a table LOGGEDREASON with a 1:n relation between them. We create a select statement of these tables and as an result we get...
  7. ThorstenB

    Virtual Cubes

    Hi, is it possible to create a virtual cube without using analysis server? I have 2 local cubes and want to build one virtual cube. Best regards, Thorsten

Part and Inventory Search

Back
Top