ContributionsMost RecentMost LikesSolutionsHow can I convert excel date integers into DateTime 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 t...SolvedRe: How to Selectively Collapse Member Expansion Headers on Cube Views? 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 woul...Re: Behaviour between Top Level cube and Cube References 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 s...Re: Behaviour between Top Level cube and Cube References 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 ...Re: Behaviour between Top Level cube and Cube References Is the cube view on the base level cube or the top one? You need to use the top level cube and consolidate from there Re: Move an entity to a new parent 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 ...Re: Behaviour between Top Level cube and Cube References Can you share the screenshot of the cube view? You should put the top level cube in pov and the entire entity hierarchy in rows. It should be entirely green if the setup is correct. Also what is the ...Re: Convert Percentage/Decimals to Basis Points in CubeView Mustafa_AIf dp_pdx asnwer is correct please mark it as a solution Thanks Re: Excel load Time Ok thanks for testing that. Since the T.C# worked instead would be be able to mark the answer as a solution? Re: Excel load Time Did you try removing the time (in this case) dimension entirely form the excel file? Lets say that generally speaking excel based load should be used for smaller amount of data and in any case the co...
