Temporary Entity
Just like we have temporary cubes in procedures sometime we need dummy entites of one or two members may be more depending upon calculations, so like temporary cubes how about having temporary entites??
Comments
-
That would be really great - had the same idea a couple of weeks ago.
1 -
Thank you for sharing your idea, @Arpan. We appreciate the time and effort you put into crafting your suggestion.
In order to evaluate this idea further, we would love to ask you if you please could provide us with more use cases?
0 -
Team, One use case that I can think of is the ability to use Time functions on the cubes which have only one of the Time entities as the dimension. In such scenarios, we need to create cubes and add dummy entities just to calculate time functions and then roll up the cube data into cubes with just the Time entity. The ability to perform such calculations without adding a dummy entity to the model would be helpful.
2 -
Hi @Navan Mehra, Thanks for the use case scenario. Also there are instances in some places where we need to fetch more than one values for the same combination of dimensions usually we have dummy dimension to fetch such values which has only one member. so we create different cubes but in case we need to fetch more such constant values we can have a temporary entity which has predefined members (can be a replica of any existing entity as well). This can surely shorten many coplex calculation logics. especially if else cases.
0