Viewing 15 posts - 166 through 180 (of 354 total)
Ive had a thought but I dont know if its doable
A top level package which runs the package with the SPs in
Set the parameters up at this level
Delete the parameters...
November 18, 2011 at 7:58 am
Still trying and failing to make sense of the data view in Analysis Services.
for example I have 3 facts
Address_Issues uses time dim
...
October 27, 2011 at 3:37 am
Thank you again forall you help.
Im going to tackle the date dimension next. I feel a fun day coming on 🙂
October 14, 2011 at 2:48 am
YEEEEEEEEEES Finally I have sorted it with the keys as follows
(And it has to be in this order to work)
SCHOOL DFEE
LEA CODE
SCH DFEE
LEA_CODE
LEA CODE
PHASE DESC
LEA CODE
LEA CODE
And the...
October 13, 2011 at 9:58 am
I found one think I did wrong within attribute relationships
I had
School_ID, Local Authority, Phase, School
Where it should be
School_ID, School, Phase, Local Authority
because Local Authority is the top level...
October 13, 2011 at 9:23 am
I cant thank you enough,
Im doing lots of other testing including installing BIDS helper to see what happens. Although every time I run it BIDS shuts itsself down so not...
October 13, 2011 at 7:19 am
Right, The only way that the school table will process is with these keys set for each level:
LEA_CODE = LEA_CODE, School_ID (2 keys)
PHASE_DESC = PHASE_DESC, LEA_CODE, School_ID (3 keys)
SCH_DFEE =...
October 13, 2011 at 6:48 am
When you say “you dont need to get rid of the data items, just make them not visible..”
Where would you hide the data items?
I did a small sample table from...
October 12, 2011 at 4:21 am
LEA_CODE is LEA_CODE and School_ID,
PHASE_DESC is PHASE_DESC, LEA_CODE and School_ID
SCH_DFEE is SCH_DFEE, PHASE_DESC, LEA_CODE and School_ID
So what Im thinking is: Do I get rid of the other data items in...
October 12, 2011 at 3:15 am
Hiya,
It does return rows but then the LEA_Code contains multiple schools. Each snould be unique. So if IDENTITY change to:
SELECT LEA_CODE , SCH_DFEE,COUNT(*)
FROM Dim.School
WHERE [Most Recent Transaction Indicator]=1
group...
October 12, 2011 at 2:20 am
so far Ive recreated and it processes fine.
Ive then set phase desc after LEA code and I immediately get the error.
Errors in the OLAP storage engine:
A duplicate attribute key...
October 11, 2011 at 10:11 am
Ive added some script to the dim SP to resolve the source error so at least thats now sorted.
Ive added my hierarchy and it works.
Does this mean I can just...
October 11, 2011 at 9:57 am
I may have figured out this one. It looks like a source error has caused there to be 2 most recent rows instead of one because the name has changed.
59016Secondary...
October 11, 2011 at 9:11 am
It just got worse. I deleted the dimesnion and recreated and then processed and now its failing based
on where SCH_DFEE= '3805'
the school DFES is used within 3 LEAs 888, 335...
October 11, 2011 at 9:04 am
Its certainly a lot more difficult to set up that I first thought.
I need to have a good old think about the hierarchy
Primary Phase has LEA code of 893 and...
October 11, 2011 at 8:42 am
Viewing 15 posts - 166 through 180 (of 354 total)