aaaaaaaaaaah, I share your pain

two points though, if the development cycle is quick enough, the users will learn to say "why doesn't...

nope

does the same i'm afraid

i've done it a different way now and it works as long as (strangely) i have something on the rows

will give to the users for testing...

use "localhost" in your connection

🙂

use two loops, one to go down the rows and one to go across the row finding spaces

you don't say what your source data is in...but try to shift it...

my point 6...

i have a fact table with ~7 million rows in it...and a field of [BuySell] that only ever has "B" or "S"

the field isn't indexed

if you create the...

deploy it in SSIS?

er..is the SSAS database and cube on the server?

can you open the cube in Visual Studio?

as a work around, you can write a script task to copy over a blank spreadsheet to your connecting spreadsheet every time instead of clearing it down...

yep

Provider=OraOLEDB.Oracle.1

how do i know if that's Oracle 10,11 - 32 or 64 bit?

how do i go from the provider name to the DLL path?

bump

😀

always worth checking the easy stuff 🙂

funny how WEEK isn't pink in the sql...

i can't run the...

utter guess....

do you have WEEK as a field name in dbo.DimTime?

and so SSAS is being verbose to distinguish between the two?

no to ODBC drivers....you may need to enter the password in the connection properties...

rjames-833409 (12/1/2010)

---

I'm a newbie in building cubes and dimensions and am having difficulting fixing a sort issue.

I have a time dimension that won't sort - I've set the dimesion to...

Mike Austin-398977 (12/8/2010)

---

All,

I've been asked to create some new cubes. I understand that this has to be done in BIDS. Do I create a new project/solution and point...

hmmm...struggling to spot it

you could see if there is an ldb on connection...

and the db or the workgroup file may be corrupted...so a compact/repair wouldn't hurt

(but i'm guessing!)