Jelle van Hulten

1. Community
2. Frontend, Designer and Consumer
3. How to Reuse an Analysis Between BA and BA_Archiv Databases (Identical Cubes, Different Historical Data)

Hi Mirza,I am not sure if this works, but perhaps by changing all cube references in the copied / new VFS file? When I open a VFS using notepad I see the following information:<defaultcube> <metada...

• View comment
• 0 votes

1. Community
2. Frontend, Designer and Consumer
3. Arrange measures above the dimension

Hi Marlene,I managed to create below crosstab, I think this is what you are looking for? In order to create this crosstab, the first thing you should do is add two columns to your date table / dime...

• View comment
• Edited May 02, 2024 06:05
• 0 votes

1. Community
2. Frontend, Designer and Consumer
3. Grouped Categories compared to total in a line chart over time

Hi Janus,I would do this as in image below. Create crosstab first with calculated columns. Then hide all columns except Category1-3, CategoryAll & %OfTotal. Finally, change cross tab to a line char...

• View comment
• Edited November 09, 2023 09:19
• 1 vote

1. Community
2. Frontend, Designer and Consumer
3. How to horizontally flip a bar chart?

Hi,Below examples are possible, however both have their limitations. Option 1 having dimensions from right to left and option 2 having a static amount of dimensions. Option 1 The above option can b...

• View comment
• Edited December 08, 2022 09:56
• 1 vote