All Questions
3 questions
0
votes
0
answers
163
views
MDX Function (Excel PowerPivot) to Exclude Non Numeric Values from DB
I am quite new to MDX and I am trying hard to write a query that allows me to retrieve only numeric values.
My query at present is:
SELECT NON EMPTY {ISNUMERIC([Measures].[Average Booking Window])} ...
- 135
0
votes
1
answer
32
views
I'm connecting a PowerPivot query to a MS Analysis server cube. double record
I'm connecting a PowerPivot query to a MS Analysis Server Cube. The query result i get contains double records for a single dimension (personnelnr). This because of a name change during a day in the ...
- 1
2
votes
2
answers
2k
views
Filter Dimension values
I have a master Customer dimension (that I don't maintain). My fact table includes customer info. When I compile the cube, everything looks good, by browsing the cube I see my fact rows with only ...
- 342