01-19-2022 09:58 AM
Hi, in the getting started with BI viewer I see they make use of a date field, which enables you to drill down to quarters/months etc. How do you create such a field (I guess I have to something with the time dimension which contains my years and months). I'm struggling with finding an expression that works...
Solved! Go to Solution.
01-20-2022 11:52 AM
Right, I think your time dim should get descriptions rather then name into the dataset. You can change it on the data adapter under Header text to "Description". This should work as long as you have the standard time dimension. You could run the data adapter and check the data.
01-19-2022 11:19 AM
Create a DateTime calculated field and then convert your Time dim to DateTime. The when you drop this field to Arguments you'll have time functions available (Month, QTR etc)
01-20-2022 11:29 AM
Hi Sai, thank you for the swiift response. This formula is accepted and I can select year/quarters etc...but apparently evaluates in an error (see below bar). Any idea why? See screenshot
01-20-2022 11:52 AM
Right, I think your time dim should get descriptions rather then name into the dataset. You can change it on the data adapter under Header text to "Description". This should work as long as you have the standard time dimension. You could run the data adapter and check the data.
01-21-2022 03:20 AM
Thank you very much Sai, very useful. Works great now.
01-21-2022 09:39 AM
In the meanwhile I've found a built-in solution that OneStream provides that is even simpler. Just go to the data adapter with the cube MD an put Add Start End Calendar Time to True (standard is false).
01-21-2022 09:46 AM
Yes true, they added this in the later versions..