The option to generate DB scripts is really great!
But currently you can only create scripts for single db objects (dimensions, cubes) or for the whole db in total.
It would be great if Jedox would offer some options to save time.
when I create a db script for a cube, I would need the option to
also create scripts for the related dimensions
in general it would be great if I could select multiple cubes and/or dimensions from a list to generate the scripts for them
Please add an option in the function to include Zero values into the calculated average.
Also add the option to PALO.DATA.CNT1 vote
Scalar1 for instance would be a dimension with predefined values from 0-100. You could assign meaningful names to each value using an alias. The benefit would be that rules requiring a previous or next value would not require a "lookup" for what the previous or next value is. This is important in nested rules. For instance in occupational modelling where next year, next age is a function of previous year, previous age.
NEXT_YEAR, NEXT_AGE = PALO.DATA("XXXDatabase","CCCube",PALO.EPREV("XXXDatabase","XXDimension",!'XXDimension'),PALO.EPREV("XXDatabase","YYDimension",!'YYDimension'),…) * …
This could be replaced with NEXT_YEAR, NEXT_AGE = PALO.DATA("XXXDatabase","CCCube",PREVIOUS("XXDimension"),PREVIOUS("YYDimension"),,…) *1 vote
- Don't see your idea?