How I do this in VB

#1

1. Count dimension members ,
2. if dimension members > 65,000 then
3. create new level, automatic grouping

I am Creating OLAP database through VB program; I want to check to see
dimension members contain more 65,000 members

--
Message posted via http://www.sqlmonster.com

#2

wow.

I would reccomend doing a select count(*) in the relational world.

ps - the numebr you're looking for is 64,000 members; not 65,000.

meghana via SQLMonster.com wrote:

Quote:

1. Count dimension members ,
2. if dimension members > 65,000 then
3. create new level, automatic grouping

I am Creating OLAP database through VB program; I want to check to see
dimension members contain more 65,000 members

--
Message posted via http://www.sqlmonster.com

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

How I do this in VB

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

How I do this in VB - 06-07-2006 , 09:11 AM

Re: How I do this in VB - 06-08-2006 , 05:09 PM