 | |
Re: Cannot drillthough with empty cells
microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Re: Cannot drillthough with empty cells -
02-16-2005
, 02:35 PM
|
When I try to drillthrough into a cube where a cell is empty. The resultset returned is always empty. For example on the "foodmart 2000/sales" cube the following MDX query returns nothing : DRILLTROUGH MAXROWS 100 SELECT FROM Sales WHERE ([Promotion Media].[All Media].[]) However I have several lines in the "foodmart 2000/sales" cube with a NULL [Promotion Media]. Does anyone know how to drillthough onto empty cells? Regards Jean-Michel DESMON VALMONT |
#2
| |||
| |||
|
|
I'm guessing this is because AS2k converts NULL values to 0s and when it does a drillthrough into the relational database, it will put the condition with [Promotion Media] = 0 instead of [Promotion Media] IS NULL. You could change the member key to be a calculated SQL expression like COALESCE( [Promotion Media], 0 ). This may work... Thanks, Akshai -- This posting is provided "AS IS" with no warranties, and confers no rights Please do not send email directly to this alias. This alias is for newsgroup purposes only. "Desmon" <desmon (AT) netcourrier (DOT) com> wrote in message news:1502f457.0502160134.33c19378 (AT) posting (DOT) google.com... When I try to drillthrough into a cube where a cell is empty. The resultset returned is always empty. For example on the "foodmart 2000/sales" cube the following MDX query returns nothing : DRILLTROUGH MAXROWS 100 SELECT FROM Sales WHERE ([Promotion Media].[All Media].[]) However I have several lines in the "foodmart 2000/sales" cube with a NULL [Promotion Media]. Does anyone know how to drillthough onto empty cells? Regards Jean-Michel DESMON VALMONT |
#3
| |||
| |||
|
|
I'm guessing this is because AS2k converts NULL values to 0s and when it does a drillthrough into the relational database, it will put the condition with [Promotion Media] = 0 instead of [Promotion Media] IS NULL. You could change the member key to be a calculated SQL expression like COALESCE( [Promotion Media], 0 ). This may work... Thanks, Akshai -- This posting is provided "AS IS" with no warranties, and confers no rights Please do not send email directly to this alias. This alias is for newsgroup purposes only. "Desmon" <desmon (AT) netcourrier (DOT) com> wrote in message news:1502f457.0502160134.33c19378 (AT) posting (DOT) google.com... When I try to drillthrough into a cube where a cell is empty. The resultset returned is always empty. For example on the "foodmart 2000/sales" cube the following MDX query returns nothing : DRILLTROUGH MAXROWS 100 SELECT FROM Sales WHERE ([Promotion Media].[All Media].[]) However I have several lines in the "foodmart 2000/sales" cube with a NULL [Promotion Media]. Does anyone know how to drillthough onto empty cells? Regards Jean-Michel DESMON VALMONT |
#4
| |||
| |||
|
|
Thanks but I would like to find a global fix. Because I have the problem for [Promotion Media] and also for ALL others fields in ALL my cubes where there is NULL value . With your fix I have to update all calculated SQL expression in all my dimensions for ALL my cubes. Any idea? JMD "Akshai Mirchandani [MS]" <akshaim (AT) online (DOT) microsoft.com> wrote I'm guessing this is because AS2k converts NULL values to 0s and when it does a drillthrough into the relational database, it will put the condition with [Promotion Media] = 0 instead of [Promotion Media] IS NULL. You could change the member key to be a calculated SQL expression like COALESCE( [Promotion Media], 0 ). This may work... Thanks, Akshai -- This posting is provided "AS IS" with no warranties, and confers no rights Please do not send email directly to this alias. This alias is for newsgroup purposes only. "Desmon" <desmon (AT) netcourrier (DOT) com> wrote in message news:1502f457.0502160134.33c19378 (AT) posting (DOT) google.com... When I try to drillthrough into a cube where a cell is empty. The resultset returned is always empty. For example on the "foodmart 2000/sales" cube the following MDX query returns nothing : DRILLTROUGH MAXROWS 100 SELECT FROM Sales WHERE ([Promotion Media].[All Media].[]) However I have several lines in the "foodmart 2000/sales" cube with a NULL [Promotion Media]. Does anyone know how to drillthough onto empty cells? Regards Jean-Michel DESMON VALMONT |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.