Well Ive sorted it even if I have done it in a completely different way, staying away from MDX. Here is my novice style solution....

http://my.opera.com/DebzE/blog/2010/03/04/named-calculation-in-the-data-set-showing-in-the-cube-structure-but-not-in-the-b

Thanks for all the...

When you say second set, do you mean CalendarTodaySet ?

exists([Dim Date Time].[Financial Year - Financial Month].[Date], [Current_date]).ITEM(0).ITEM(0)

I didn’t understand this bit.

I now have the named sets Current_date, calendarTodaySet (These...

Well I knew It wouldn’t take long to get stuck again :doze:

Going through the documentation in http://my.opera.com/duncans/blog/using-custom-sets-in-analysis-services-to-deliver-special-date-ranges-to-end-use

After creating the first names set sorted out with your help...

Sorry to be appearing dim but I am no where near as advanced as the solutions you have. Im a beginner at MDX but I know what attribues and members...

denglishbi (3/2/2010)

---

Do you even have the Date member in the hierarchy to reference? It looks like you just have Year and Month based on the name. The TimeID...

Hello again,

Looked through the documentation and I still cant get it to work. Here is what I have done so far.

Right Clicked the cube to Open.

Gone to the calculations table...

Excellent.

Thanks for that. Ill have a read 🙂

Debbie

Fantastic,

So I need to do a bit of research on sets in cubes? I dont suppose you would know of any literate or web pages that could give me some...

Thank you loads for these. Were going to have a go at these and let you know how we get on 😀

Debbie

Excellent. It looks like it works. I have added an IS NULL(Date, DateDate()) so open ones count right up to todays date.

Thanks

Debbie

Sorry for the late reply. Its not Students Achieve software. Im going on a course next week in regards to business intelligence so Im going to take the issue there...

I think it was because in value I had added ''. E.g.'Term 1' rather than just putting Term 1. Fingers crossed its working fine now.

Debbie

Hi,

the default value is (-1) which means that the correct size is guessed at.http://blogs.msdn.com/mattm/archive/2007/02/27/sql-server-sp2-what-s-new-for-ssis.aspx

I will certainly have a go at putting another size in to see what...

Hi again,

Both computers are connecting to the same server where all the details are stored. Nothing is stored locally on any machine.

Debbie

stevefromOZ (6/26/2009)

---

Hey Debbie,

It's not clear so i'll ask - with the project that's full of reports on *your system*, have you published to a central Reporting Services server?

It almost sounds...