Question about multiple values in Discover <Restrictions>

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

From: Chris Keith (chrisxkeith_at_hotmail.com)
Date: 10/21/04

Next message: Mark A Morris: "Does anyone have the optmized xamd.xsl"
Previous message: Akshai Mirchandani [MS]: "Re: Caching of Data in IIS / PTS"
Next in thread: Akshai Mirchandani [MS]: "Re: Question about multiple values in Discover <Restrictions>"
Reply: Akshai Mirchandani [MS]: "Re: Question about multiple values in Discover <Restrictions>"
Messages sorted by: [ date ] [ thread ]

Date: 21 Oct 2004 14:15:45 -0700

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

Next message: Mark A Morris: "Does anyone have the optmized xamd.xsl"
Previous message: Akshai Mirchandani [MS]: "Re: Caching of Data in IIS / PTS"
Next in thread: Akshai Mirchandani [MS]: "Re: Question about multiple values in Discover <Restrictions>"
Reply: Akshai Mirchandani [MS]: "Re: Question about multiple values in Discover <Restrictions>"
Messages sorted by: [ date ] [ thread ]