en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
john.gordos  
#1 Posted : Tuesday, November 13, 2012 7:08:25 PM(UTC)
john.gordos
Rank: Newbie

Groups: extranet\Forum
Joined: 11/13/2012(UTC)
Posts: 2

Is there any way to do a computed measure?

Is there a way to compute the number of days between 2 dates, and use that as a measure?

Thanks,
(I'm a Targit rookie)
-john

Páll Bjarkason  
#2 Posted : Wednesday, November 14, 2012 8:53:57 AM(UTC)
Páll Bjarkason
Rank: Advanced Member

Groups: extranet\Forum
Joined: 1/13/2012(UTC)
Posts: 154

Do you have the dates as a measure?
Please give an example of your problem.
Best regards

Páll, CTS
john.gordos  
#3 Posted : Thursday, November 15, 2012 8:45:01 PM(UTC)
john.gordos
Rank: Newbie

Groups: extranet\Forum
Joined: 11/13/2012(UTC)
Posts: 2

The dates are a dimension, not a measure.

An example:

Orders have Order Dates, and quantities.

The Order# is the row dimension
the order date is the column dimension
the quantities are the measure.

Is there a way to compute "How old" an order is, in days?

In other words... Today is 2012-11-15. Order date is 2012-11-10. Order is 5 days old.

The result, 5, would be desired as a "computed measure".

Hope this helps,
-j
Páll Bjarkason  
#4 Posted : Friday, November 16, 2012 11:00:17 AM(UTC)
Páll Bjarkason
Rank: Advanced Member

Groups: extranet\Forum
Joined: 1/13/2012(UTC)
Posts: 154

You cannot datediff directly on two dimensional values. You have to build the datediff in then cube as a measure.
All calculations in the TARGIT BI Suite are based on measures and the dimensions are only pointers to identifying the decried measure.
You can reference a specific dimension but you will always return the measure and not the dimensional value. I.e. you will not get 2012-11-15.

You can do a count of the number of elements (number of days), but this is not a fool proof method and requires stable and predictable data.

PS Ole Dyring can make a correction if needed.

Edited by user Friday, November 16, 2012 12:13:24 PM(UTC)  | Reason: count, correction

Best regards

Páll, CTS
Users browsing this topic
Anonymous
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Notification

Icon
Error