Conversion from Time (text stored in Text cube) to number?

Mark Cosham

In Board 10 we used two text cubes for data entry for start and end times and cube with a nexel formula in the Data View to calculate the difference using value to convert from a time to a number. e.g. =value([@a;*;*])-value([@b;*;*])
While this displays properly in the data view, in Board 12 the result no longer gets stored to the cube.
There does not seem to be any functionality in Data Flows that can achieve this either.

Has anybody else come across this or have any suggestions as to alternatives?

------------------------------
Mark Cosham
Business Consultant
LIGHTARC PTY LTD
Australia
------------------------------

Michael Merlo

Hi Mark,

you can use the "Extract & Reload" feature to get what you need. Extract a layout with the two cubes containing the time and then reload on a single cube by subtracting the two times in ETL.

In the final dataview you can insert the two time cubes and the just calculated single cube containing the difference

Regards,

------------------------------
Michael Merlo
Business Intelligence Consultant
ADVISON SRL
Italy
------------------------------
-------------------------------------------

Mark Cosham

Thanks Michael. It's disappointing that something that used to be able to be done with a single formula within the data view now requires a procedure and more steps.

------------------------------
Mark Cosham
Business Consultant
LIGHTARC PTY LTD
Australia
------------------------------
-------------------------------------------

Stephane Joly

It is apparently a known regression. I try to have a correction date but no news at this time. I saw that there were some corrections on nexel in the latest 12 version (end of september) , may be it is corrected there ?

------------------------------
Stephane Joly
Manager
CGI France
France
------------------------------
-------------------------------------------