Re: Question about multiple values in Discover <Restrictions>

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Akshai Mirchandani [MS] (akshaim_at_online.microsoft.com)
Date: 10/27/04 

Date: Tue, 26 Oct 2004 21:31:37 -0700

I think what you want is

<CUBE_NAME>
    <Value>Sales</Value>
    <Value>HR</Value>
</CUBE_NAME>

(In the XMLA 1.1 spec:

When needed, a column can be restricted with multiple values. Each value is
represented in a <Value> element. An example follows:

<RestrictionList>

 <LiteralName>

  <Value>DBLITERAL_QUOTE_PREFIX</Value>

  <Value>DBLITERAL_QUOTE_SUFFIX</Value>

  <Value>DBLITERAL_ESCAPE_UNDERSCORE_PREFIX</Value>

  <Value>DBLITERAL_ESCAPE_UNDERSCORE_SUFFIX</Value>

 </LiteralName>

 ...

</RestrictionList>

)

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.
"Chris Keith" <chrisxkeith@hotmail.com> wrote in message
news:ceaf31b9.0410211315.633b6756@posting.google.com...
> We are trying to figure out how to specify multiple values in
> <Restrictions>.  For example, doing this for MDSCHEMA_DIMENSIONS:
>
> <Restrictions>
>  <RestrictionList>
>   <CATALOG_NAME>Foodmart 2000</CATALOG_NAME>
>   <CUBE_NAME>Sales</CUBE_NAME>
>  </RestrictionList>
>  <RestrictionList>
>   <CATALOG_NAME>Foodmart 2000</CATALOG_NAME>
>   <CUBE_NAME>HR</CUBE_NAME>
>  </RestrictionList>
> </Restrictions>
>
> returns dimensions for "Sales" only, while doing this:
>
> <Restrictions>
>  <RestrictionList>
>   <CATALOG_NAME>Foodmart 2000</CATALOG_NAME>
>   <CUBE_NAME>Sales</CUBE_NAME>
>   <CUBE_NAME>HR</CUBE_NAME>
>  </RestrictionList>
> </Restrictions>
>
>
> returns dimension for "HR" only.
>
> Thanks in advance for any help.
> Chris

Relevant Pages

  • Re: Question about multiple values in Discover <Restrictions>
    ... In the XMLA SDK, the ... multiple value restriction only works for the restrictions in the XMLA spec ... Please do not send email directly to this alias. ... "Chris Keith" wrote in message ...
    (microsoft.public.data.xmlanalysis)
  • Re: SoA Vs OO
    ... > Someone (as quoted by Topmind) wrote: ... > factor at multiple levels, since the factoring at different levels is ... > hierarchy representing the semantic structure, ... > takes muliple dimensions and maps them onto an ordering in one ...
    (comp.object)
  • Re: SoA Vs OO
    ... > Someone (as quoted by Topmind) wrote: ... > factor at multiple levels, since the factoring at different levels is ... > hierarchy representing the semantic structure, ... > takes muliple dimensions and maps them onto an ordering in one ...
    (comp.programming)
  • Re: SoA Vs OO
    ... Someone (as quoted by Topmind) wrote: ... > because they often interact in multiple dimensions, ... factor at multiple levels, since the factoring at different levels is ... hierarchy representing the semantic structure, ...
    (comp.programming)
  • Re: SoA Vs OO
    ... Someone (as quoted by Topmind) wrote: ... > because they often interact in multiple dimensions, ... factor at multiple levels, since the factoring at different levels is ... hierarchy representing the semantic structure, ...
    (comp.object)