Creating a 3500 Line Query

#1

What would be the easiest way to create a 3500 line MDX query from the
Foodmart Database or the Adventureworks database. I need to create a
huge MDX query to test the maximum number of lines of a query.

#2

There is 64K limit for MDX query size.

Vladimir Chtepa

<dilip_kulasingam (AT) hotmail (DOT) com> schrieb im Newsbeitrag
news:1128364881.514385.53500 (AT) g47g2000cwa (DOT) googlegroups.com...

Quote:

What would be the easiest way to create a 3500 line MDX query from the
Foodmart Database or the Adventureworks database. I need to create a
huge MDX query to test the maximum number of lines of a query.

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

Creating a 3500 Line Query

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

Creating a 3500 Line Query - 10-03-2005 , 01:41 PM

Re: Creating a 3500 Line Query - 10-03-2005 , 06:55 PM