Brian Sandfeld

Dimensions with NULL value are not visible

1. Community
2. Data Warehouse Developer

Hi  I am expecting a result like this, where members with empty dimension values are visible. However, I do get a result like this, where all rows with empty dimension values are excluded.   Wher...

• Created June 02, 2023 11:50
• 2 followers
• 0 comments
• 0 votes

Number format in InMemory

1. Community
2. Data Warehouse Developer

I got a problem with Excel data imported to InMemory ETL. The (Measure) data is being read as string and I want to format it with a CAST function.  However, none of the normal Cast functions seems ...

• Created July 06, 2022 07:58
• 2 followers
• 1 comment
• 0 votes

Subtotal of visible rows

1. Community
2. User Tips and Tricks

Is there a way to calculate the subtotal of the visible rows and show the subtotal under a certain dimension. In the below example I will like to show the correct subtotal of each column for every ...

• Created October 31, 2021 08:38
• 2 followers
• 2 comments
• 0 votes