Viewing 15 posts - 106 through 120 (of 137 total)
I was a high school maths and IT teacher. I was reduced to teaching MS Works due to nothing else being licensed by the school. I...
September 22, 2003 at 4:20 am
quote:
if you're into using beta s/w, the beta for ADOMD.Net is out, which would remove any interop issues.
September 22, 2003 at 2:05 am
Why would you ever want to set this up? 4A/2P makes sense, but 2A/4P? Pay two whole extra processor lics for a server that you hardly ever...
September 22, 2003 at 1:52 am
Cool, but boy thats ugly. You're getting the same resultset as if you just got a OLEDB recordset object straight from MSOLAP, which is what I guess...
September 19, 2003 at 9:18 am
All I was saying is that I had a rough idea on the day about how many people got the answer, and today 80% have got it by...
September 19, 2003 at 7:05 am
quote:
But I'm running an MDX query using the SQL stored procedure. When I get the resultset back in QA
September 19, 2003 at 2:27 am
quote:
Access As The UI With Linked Tables From SQL Server
Never never ever...
September 18, 2003 at 2:20 am
You can also use any VBA or Excel functions in calculated measures
Keith Henry
DBA/Developer/BI Manager
September 18, 2003 at 2:14 am
Just to confuse things Access 2000 on can use sql as the back end. The choice is not Access vs SQL but "MS Jet 4.0 Engine" vs...
September 17, 2003 at 8:39 am
How about
filter( {
descendants([startdatedim].[all],[year],self_and_after)
* descendants([enddatedim].[all],[year],self_and_after)
September 17, 2003 at 7:02 am
Could be related to SSPI/Kerberos as MSOLAP is notoriously difficult with NT Security delegates and the like. Look at what account IIS connects to MSOLAP under and...
September 17, 2003 at 3:34 am
You can remove the "all" level, but part of the point of dimensions is this combination of values (can be SUM, COUNT, AVG)
Keith Henry
September 17, 2003 at 3:29 am
Not in one cube. All measures will be availiable at all levels. You can remove the "All" level of a dimension if totals don't make sense. ...
September 17, 2003 at 3:27 am
MDX slices don't work like SQL where clauses. You don't have fields as such, just members of dimensions
Say you wanted all data between two dates:...
September 17, 2003 at 2:51 am
Viewing 15 posts - 106 through 120 (of 137 total)