MDX on current background selection

MDX on current background selection

Post by Tore Johnse » Thu, 26 Jun 2003 21:20:19



OLAP brothers and sisters

if i have selected > 1 member on the time dimension, the Time.currentmember
returns something like Time.aggregation. Is there any way of  for example
returning the last member selected through a function like TAIL() ? I think
it's not, but if you know a way I'd vote for you receiving the Nobel Prize
of informatics.. if that existed, that is.

Tore

 
 
 

MDX on current background selection

Post by Anne Zorner [MSF » Fri, 27 Jun 2003 17:52:29


Hi Tore

if I do

select {[Measures].[Units Shipped],[Measures].[Units Ordered]} on columns,
TAIL({[Time].[1998],[Time].[1997]},1) on rows
from warehouse

 in Foodmart 2000

then I get

                Units Shipped       Units Ordered
1997         207,726                  227,238

Why isnt this doing what you need? You seem to have answered your own
question?

regards

Anne

This posting is provided "AS IS" with no warranties, and
 confers no rights.

--------------------

| Subject: MDX on current background selection
| Date: Wed, 25 Jun 2003 13:20:19 +0100
| Lines: 13
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 5.50.4922.1500
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4925.2800

| Newsgroups: microsoft.public.sqlserver.olap
| NNTP-Posting-Host: 62.48.162.116
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.olap:39966
| X-Tomcat-NG: microsoft.public.sqlserver.olap
|
| OLAP brothers and sisters
|
| if i have selected > 1 member on the time dimension, the
Time.currentmember
| returns something like Time.aggregation. Is there any way of  for example
| returning the last member selected through a function like TAIL() ? I
think
| it's not, but if you know a way I'd vote for you receiving the Nobel Prize
| of informatics.. if that existed, that is.
|
| Tore
|
|
|
|
|

 
 
 

MDX on current background selection

Post by Tore Johnse » Fri, 27 Jun 2003 19:17:41


Hi Anne, et al.
yes this is what i want, but your code has hardcoded the selection. I don't
know what the user will define on the time dimension. The question is: how
can I obtain the unknown set {[Time].[?],[Time].[?]} dynamically ? I tried
using a range { x: y} but can't make it dynamic using only MDX. Thanks a
lot..

Greetings
Tore Johnsen



> Hi Tore

> if I do

> select {[Measures].[Units Shipped],[Measures].[Units Ordered]} on columns,
> TAIL({[Time].[1998],[Time].[1997]},1) on rows
> from warehouse

>  in Foodmart 2000

> then I get

>                 Units Shipped       Units Ordered
> 1997         207,726                  227,238

> Why isnt this doing what you need? You seem to have answered your own
> question?

> regards

> Anne

> This posting is provided "AS IS" with no warranties, and
>  confers no rights.

> --------------------

> | Subject: MDX on current background selection
> | Date: Wed, 25 Jun 2003 13:20:19 +0100
> | Lines: 13
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 5.50.4922.1500
> | X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4925.2800

> | Newsgroups: microsoft.public.sqlserver.olap
> | NNTP-Posting-Host: 62.48.162.116
> | Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
> | Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.olap:39966
> | X-Tomcat-NG: microsoft.public.sqlserver.olap
> |
> | OLAP brothers and sisters
> |
> | if i have selected > 1 member on the time dimension, the
> Time.currentmember
> | returns something like Time.aggregation. Is there any way of  for
example
> | returning the last member selected through a function like TAIL() ? I
> think
> | it's not, but if you know a way I'd vote for you receiving the Nobel
Prize
> | of informatics.. if that existed, that is.
> |
> | Tore
> |
> |
> |
> |
> |

 
 
 

MDX on current background selection

Post by Tore Johnse » Wed, 02 Jul 2003 01:21:23


I guess it's impossible then
Tore



> Hi Anne, et al.
> yes this is what i want, but your code has hardcoded the selection. I
don't
> know what the user will define on the time dimension. The question is: how
> can I obtain the unknown set {[Time].[?],[Time].[?]} dynamically ? I tried
> using a range { x: y} but can't make it dynamic using only MDX. Thanks a
> lot..

> Greetings
> Tore Johnsen



> > Hi Tore

> > if I do

> > select {[Measures].[Units Shipped],[Measures].[Units Ordered]} on
columns,
> > TAIL({[Time].[1998],[Time].[1997]},1) on rows
> > from warehouse

> >  in Foodmart 2000

> > then I get

> >                 Units Shipped       Units Ordered
> > 1997         207,726                  227,238

> > Why isnt this doing what you need? You seem to have answered your own
> > question?

> > regards

> > Anne

> > This posting is provided "AS IS" with no warranties, and
> >  confers no rights.

> > --------------------

> > | Subject: MDX on current background selection
> > | Date: Wed, 25 Jun 2003 13:20:19 +0100
> > | Lines: 13
> > | X-Priority: 3
> > | X-MSMail-Priority: Normal
> > | X-Newsreader: Microsoft Outlook Express 5.50.4922.1500
> > | X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4925.2800

> > | Newsgroups: microsoft.public.sqlserver.olap
> > | NNTP-Posting-Host: 62.48.162.116
> > | Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
> > | Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.olap:39966
> > | X-Tomcat-NG: microsoft.public.sqlserver.olap
> > |
> > | OLAP brothers and sisters
> > |
> > | if i have selected > 1 member on the time dimension, the
> > Time.currentmember
> > | returns something like Time.aggregation. Is there any way of  for
> example
> > | returning the last member selected through a function like TAIL() ? I
> > think
> > | it's not, but if you know a way I'd vote for you receiving the Nobel
> Prize
> > | of informatics.. if that existed, that is.
> > |
> > | Tore
> > |
> > |
> > |
> > |
> > |

 
 
 

1. Selection on base cube in MDX

Hi,

How do you make selections similar to SQL's WHERE clause in MDX?

Say, I have a cube with dimensions Time, Product and Store and measure
Sales. Then I would like Sales by Time.Year and Product.Country, but
only for Sales > 100 in the base cube. That is, for each combination
of Time.Day, Product.ProductName, and Store.StoreName the Sales must
be more than 100. How do I do this in an MDX query?

Regards,
Dennis

2. Roles on AS2000

3. Cr Rpts selection formula not current

4. Compile failure in ecpg/pgtypeslib/numeric.c

5. MDX - Current Member

6. Problem with comparing converted dates

7. MDX Error with Current Year's

8. When will VFP be released?

9. Computing current age in MDX

10. MDX - Current Logged in User

11. MDX based on current date

12. MDX: "unbindable in the current context"

13. MDX BRAIN_TWISTER: Percent contribution of current slice