Hiya,

They are self referencing in a way. I used to have them seperate but mostly I only need school info when discussing attendances and after lots of reading it seemed...

I created another fact table with all the statemented facts in and it was fine.

Is it the measure display folders ?

I’m going to create another tester table with everything...

Even stranger.

I created another fact table with just a few facts and it works fine.

SEN, SEN main Stream and As at January

It doesnt work with all the facts in the...

Really struggling, Im not able to move on from this issue at all. Ill try and start again with a few extra fact details (3)

Explore the fact table

TimeIDChildSENSEN MainstreamAs at...

I...

I believe the facts are correct and you are right there is more than one fact in the cube. I didnt mention the other ones but this might give you...

Ooooooh Ill have a look at this!

I know I have got different year types in my dimension like Financial and standard. I dont think I sent academic up.

Thankyou...Something to do...

Found the aggregate functions on the measures.

Changing the aggregate function of my facts. In Cube Structure right click on the measures and go to properties. See Aggregate functions

They...

Where do you do this? I can certainly check this, I...

Ive just tried changing NULL to 0 and the exact same thing is happening.

Ive googled and come up with nothing on this issue.

Im running out of tests I can do.

:crying:

SO what I have done is change the fact tabled to a Named query.

Within the query I have added the criteria of WHERE PUPIL = 2568 So there is...

Hi again,

Thanks for the offer of help. I cant believe Im having so many problems with something that should be so simple.

I decided to try connecting to an excel destination...

Im going to replace the data source and reconnect to see if this helps. I will let you know what I find.

stevefromOZ (2/7/2012)

---

So you've set Fact_SEN_CHILD as a measure? If so, what is the aggregation type set to?

Also, if you right click in the DSV and view data,...

Whoops Sorry I posted into the wrong thread....