Forum Stats

  • 3,824,773 Users
  • 2,260,416 Discussions
  • 7,896,309 Comments

Discussions

AWM- How to make a cube from query ?

2877737
2877737 Member Posts: 45

Hi,

I'm beginner in AWM but I understand what is cube, fact and dimension tabels, measures etc.

My problem is, that I have untipical star schema.

I have one fact table including 18 milions rows and one time dimension table.

Each row in the fact table has name of a task, date when task was running (date (FK) + name is PK), time of start task and time of end task.

I want to build a cube to analyze processes in my system.

The problem is, that one task isn't one process.

Usually one task starts a process and another ends it.

e.g.

task AAA starts process at 10:22 ( column start_zad in fact table)

task BBB ends process at 12:45 (column stop_zad in fact table)

So I can buid a query to report how long last this proces. I would like to implement it in AWM adding measures , hierarchy.

Thanks for all help.

Paul.

This discussion has been closed.