This the OutPut of my Excel file :
I want to Change the date to be more comprehensible. Thanks for your Help
Asked
Active
Viewed 53 times
0
-
`more comprehensible` what does that mean exactly? – findwindow Apr 20 '16 at 16:27
-
Ok, for this example , i want just 2014-08-07 , the date must be simple – Baini.Marouane Apr 20 '16 at 16:34
-
Easy to do in Excel. No idea what iccube is. – findwindow Apr 20 '16 at 16:40
1 Answers
0
This is known issue, will be part of next release.
As a workaround you can use DateToString function in your measure.
DateToString function does not convert currently, will be done in the next release, measures to their values (see issues).
As a workaround you'll have to do this manually :
[Measures].[My Date].value
or
[Measures].[My Date].value->asValue()
The second is needed if you're using a special aggregation method (e.g. min/max/open/close ) and will need Java to be active in icCube (doc)
ic3
- 7,917
- 14
- 67
- 115
-
I added an image to explain for you about "DateToString" , Thank you for your help. – Baini.Marouane Apr 22 '16 at 07:35
-