stevefromOZ (9/28/2010)

---

SSAS doesn't currently support > 1 P-C hierarchy per dimension 🙁 If you don't want to create two separate dimensions, only alternative that i would see is to...

my 2p...

pro-SQL

any power users that use SQL are unlikely to know or switch to MDX. as a rule, a fair amount of people will know SQL, but very few MDX....

number of twitter users using the site to answer their homework questions

😀

(without knowing much about sharepoint...)

sounds like a permissions issue

how about copying it to a local temporary directory and then connecting?

are you developing on the dev server or on a desktop?

i ususally develop on the dev server and use "localhost" in my connections...

how are you processing your cube?

you will need to do it in MDX

use SSMS to create an MDX query, it's easier than doing it in VS, you get the intellisense and drag-n-drop

it will be something...

make a dimension from your primary key and do a reconciliation

got it, was a case of registering the DLLs

Lowell (4/28/2010)

---

the 64 bit drivers are not named odbcad32; I'm very sure they have a different name,and contain "64" in their name.

that's the issue i think; trying to use...

hi, thanks for the quick reply

surely they have the 64 bit drivers installed if i can see it in the 64 bit odbcad32 and create a working DSN there?

aha!

many thanks

aha, just had the same problem myself

open the database in SSMS and right click on the dimension, script dimension as, create to

change the ID to whatever you like and change...

ok, got this working, although not brilliantly

firstly: whilst there is no DistinctSum, there is a DistinctCount, use this and get it working with the thing you want to DistinctSum to...

here's my 2p

print convert(datetime,cast(2009*10000+3*100 + 5 as varchar(8)),112)

just wondered exactly the same question...in fact here is my last day of the month bit

set @DealDateTo=dateadd(dd,-1,dateadd(mm,1,convert(datetime,cast(@DealYear*10000+@DealMonth*100 + 1 as varchar(8)),112)))