Re: how to bring up MDX query window

#1

You can enter/test queries using the MDX Sample App that installs along with
the product.

public @ the domain below
www.tomchester.net

"anna" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:

How do I bring up the query window to type and run a query to create a new
dimension member in Analysis Services? I only have cube editor and dimention

editor... If I add a new calcualted member and set the parent dimension to
rpt (not measures), I cannot use "WITH MEMBER......" key word in the "Value
expression" window and the new member appears in the calculated member
section of the cube editor other than as a member of rpt dimension.

#2

Oh, I didn't get it ... to persist a calculation you use the Cube Editor.
(Right-click cube, edit, right click Calc Members, New)

"WITH MEMBER" is used to create calcs on-the-fly as part of a SELECT
statement -- you do NOT enter this in the Cube Editor, just the formula.

public @ the domain below
www.tomchester.net

"anna" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:

Thanks Tom.
Ok... I got the query correct and saved away the .MDX file. Now how do I
make this new member available in the Cube/Dimention for my users to use?

----- Tom Chester wrote: -----

You can enter/test queries using the MDX Sample App that installs
along with
the product.

public @ the domain below
www.tomchester.net

"anna" <anonymous (AT) discussions (DOT) microsoft.com> wrote in message
news:C4793B46-4067-48F5-B66D-A41EABB8F932 (AT) microsoft (DOT) com...
How do I bring up the query window to type and run a query to
create a new
dimension member in Analysis Services? I only have cube editor and
dimention
editor... If I add a new calcualted member and set the parent
dimension to
rpt (not measures), I cannot use "WITH MEMBER......" key word in the
"Value
expression" window and the new member appears in the calculated
member
section of the cube editor other than as a member of rpt dimension.

#3

Thanks Tom. My fault... I need to copy and paste the formula to the cube edit area to create a member that will be permanently avilable when browsing. I don't know what on-the-fly members would be used for yet

----- Tom Chester wrote: ----

Oh, I didn't get it ... to persist a calculation you use the Cube Editor
(Right-click cube, edit, right click Calc Members, New

"WITH MEMBER" is used to create calcs on-the-fly as part of a SELEC
statement -- you do NOT enter this in the Cube Editor, just the formula

public @ the domain belo
www.tomchester.ne

"anna" <anonymous (AT) discussions (DOT) microsoft.com> wrote in messag
news:4F140BA5-B62E-46FF-9D49-27AB2CF8AF66 (AT) microsoft (DOT) com..

Quote:

Thanks Tom
Ok... I got the query correct and saved away the .MDX file. Now how do
make this new member available in the Cube/Dimention for my users to use
----- Tom Chester wrote: ----
You can enter/test queries using the MDX Sample App that install
along wit
the product
public @ the domain belo
www.tomchester.ne
"anna" <anonymous (AT) discussions (DOT) microsoft.com> wrote in messag
news:C4793B46-4067-48F5-B66D-A41EABB8F932 (AT) microsoft (DOT) com..
How do I bring up the query window to type and run a query t
create a ne
dimension member in Analysis Services? I only have cube editor an
dimentio
editor... If I add a new calcualted member and set the paren
dimension t
rpt (not measures), I cannot use "WITH MEMBER......" key word in th
"Valu
expression" window and the new member appears in the calculate
membe
section of the cube editor other than as a member of rpt dimension

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: how to bring up MDX query window

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Re: how to bring up MDX query window - 04-07-2004 , 01:14 PM

Re: how to bring up MDX query window - 04-07-2004 , 04:46 PM

Re: how to bring up MDX query window - 04-07-2004 , 05:46 PM