I have a csv import coming from excel. One of the columns is of type
date but when it gets saved into CSV the date is replaced by integers in
the format excel uses to store dates. How can I convert those integers
back into dates?
Correct, row expansion is a global setting for the cube view, it is not
possible to selectively start expanded a single member expansion, unless
you use a non expandable selection, like list. It would be possible to
parametrize rows with parameters i...
If the cell in invalid it means the cubes are not properly setup. You
might have some of the dimensions not assigned properly or something
else. Reach out internally, no point discussing basic cube setup here
Why is none in there? Are you on Top of the consolidation dimension as
well? When you say "The Total goes green if I select base element from
the dimensions of this top cube" which dimensions to you refer to?
You cannot move an element to a different dimension while keeping the
data. You can change relationships to an existing element effectively
having it rolling up to a different parent, potentially in a different
dimension, but the element itself canno...