Need help with calculation

[jaburke]

Hello. I have a webi doc and I need to create some date calculations. I'm not sure if I should do this in the webi or in the universe. Here's how the data looks:

Customer1 MRP Planning 8/1/2009
Customer1 ME Planning 10/5/2009
Customer1 Capacity Planning 10/25/2009
Customer1 Task Planning 8/25/2009

They want to create a variable/formula that contains the number of days between two of the rows. They want this:

Customer1 MRP Planning 4 days 10/1/2009 (calculated by me planning - mrp planning)
Customer1 ME Planning 20 days 10/5/2009 24 days (calculated by task planning - ME planning)
Customer1 Capacity Planning 20 days 10/25/2009 (calculated by capacity planning - me planning)
Customer1 Task Planning 60 days (calculated by capacity planning - task planning)

Can this be done easily? Can it be done in Webi or should I create new measures in the universe? Any help would be appreciated. I am rusty with these kinds of calculations.

 

[hilfy]

You'll need to create new measures in the universe - I don't think it can be done in the report itself. If you're running out of a data warehouse and not out of production data, it would be even better to have this pre-calculated in the database because I believe it will probably take a derived table for EACH of these.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[skrandel]

You could do it on the report by creating the buckets you need and hardcoding things with the WHERE operator. Then use the daysbetween function for the math.

However, WAY better to do this at the database/universe level.

Steve Krandel
Intuit