Is it possible to change time format of a dimension in data cube dynamically in runtime

betasharko
edited February 11, 2022 in Analytics #1

Hello!
I have one problem. My report contains a data cube where one of dimensions is time (a distribution of a value in time). Based on this data cube, there's a crosstab in the report's body. Based on crosstab, a chart is created. But as well, user can select time range (one year, one month, one day, or a custom time period) in the report's parameters. But if I set hardly time dimension's format in the data cube as Month, for example, so it will be working perfect for some year selected in parameters, but bad for some month or day. So the question is, is it possible to dynamically in runtime update type of formatting for time dimension in data cube? Or may be my approach is bad originally?
Thank you very much in advance!

Answers

  • Can you help answer this question?

    We have noticed this question is over 30 days old and hasn't received a response. We're turning to you, the community, to help answer it.

    This generic response is intended to prompt discussion in this post. The question remains open to your answers, suggestions, and best practices.

    If you posted this question, what additional information can you provide to help us respond to you? Were able to resolve the issue? Please share your solution here with others. If you still need additional help, though, please let us know. Your question and its resolution are important to us, and we want to help.

    • Please note that questions to the developer network are typically peer-to-peer, best effort responses. If you are a customer of the product about which you're inquiring, please consider moving this post to the product forum where it may receive more attention from our experts.

    • Additionally, note that posting questions to General may not be answered by a product expert. The General forum is for non-product questions. Please be sure to post your product-specific questions to the proper product forum.

    David Sciuto