topic How can we convert a Measure into a Dimension? in App Development

How can we convert a Measure into a Dimension?

litinkumar — Wed, 16 May 2018 08:07:47 GMT

How can we covert a metric into a dimension at the same time maintain the cross dimensional association between various dimensions.

For Example: I've to bucket payment into categories such as (0-1000,1000-2000.. etc.). At the same time be able to slice the data based on multiple dimensions.

One of the option that I had in mind was to use the aggr function: aggr(sum(payment),dimension1,dimension2,dimension3..etc) but this was failing as the data is too big and I'm getting a 'Calculation timed out' error

Another option was to get the sum(payment) in the back-end and group them by all the dimensions but this was resulting in a Synthetic key creation as I have a table with the similar dimensions which is being used to create Other views in the same app

Re: How can we convert a Measure into a Dimension?

YoussefBelloum — Wed, 16 May 2018 08:17:00 GMT

Hi,

would you be able to share sample app to see what you have so far ?

Re: How can we convert a Measure into a Dimension?

litinkumar — Wed, 16 May 2018 08:18:27 GMT

I'm afraid I won't be able to do that since my app is on a virtual machine.

Re: How can we convert a Measure into a Dimension?

litinkumar — Wed, 16 May 2018 08:19:20 GMT

I'm afraid I won't be able to do that since my app is on a virtual machine.

Re: How can we convert a Measure into a Dimension?

YoussefBelloum — Wed, 16 May 2018 08:25:12 GMT

you can maybe create a quick LOAD INLINE which represent your data structure ?