Viewing 15 posts - 16 through 30 (of 137 total)
quote:
Seems like there is something missing from the question as the answers refer to do the above 1,2,3 and 4 then else....
December 22, 2003 at 7:57 am
Try giving the account MSOLAP runs under read access to the SQL server you need to connect to.
Keith Henry
DBA/Developer/BI Manager
December 18, 2003 at 2:16 am
Someone else had a similar problem here:
Keith Henry
DBA/Developer/BI Manager
December 18, 2003 at 2:00 am
How are you processing the cube? In Analysis Manager or DTS or DSO etc. Are you using Windows NT security or SQL security on your source...
December 18, 2003 at 1:56 am
But this one has the correct date
Keith Henry
DBA/Developer/BI Manager
December 18, 2003 at 1:53 am
Why is the plan bad? Could you execute the following on each:
set showplan_text on
go
/* Your query here */
December 17, 2003 at 6:25 am
It can depend on the exact nature of the sub query, if you have a sort of some kind, for instance, it will completely change the query plan....
December 17, 2003 at 6:15 am
What SQL are you trying to execute and what on?
Keith Henry
DBA/Developer/BI Manager
December 17, 2003 at 6:07 am
Beginners should look at:
"Fast Track to MDX" ISBN: 1-852-33681-1
Good beginners stuff but lacking in detail.
More expirenced users will need:
"MDX...
December 17, 2003 at 5:50 am
Ah Ha, I thought, clever trick question with an answer most will pick that will remove the top 5% of their sales team. I pick the right...
December 17, 2003 at 2:57 am
select x.* from
#xx x
inner join (
Select Col2, Max(COl3) as 'mxCOl3' From #xx
Group By Col2 ) g
on ...
December 9, 2003 at 9:08 am
What do you mean? The statistics for an index could become out of sync if you did a large insert, update or delete in certain conditions. ...
December 9, 2003 at 9:04 am
quote:
I've worked at places where they've let trained (or untrained sometimes) end users use QA or tools like QA (depending on the...
December 9, 2003 at 8:54 am
Build the cube with a month dimension that you can total the change on that month.
Then either handle it in the client app or:
with
December 9, 2003 at 2:23 am
Not adversly. The answer to the question is technically right from a pure SQL point of view, but not from an application point of view. You're...
December 9, 2003 at 2:06 am
Viewing 15 posts - 16 through 30 (of 137 total)