摘要:
Debellor is an open source framework for scalable data mining and machine learning. You may implement your own algorithms in Debellor's architecture and combine them with pre-existing ones to create c... 阅读全文
摘要:
Time MDX Cheat SheetHow do you get Last month in the time dimensionSELECT ClosingPeriod([Date].[Calendar].[Month], [Date].[Calendar].DefaultMember) ON 0FROM [Sales Summary]WHERE ([Measures].[Sales Amo... 阅读全文
摘要:
create or replace view v_timedimension asselect to_date(a.STARTTIME,'yyyy-mm-dd hh24:mi:ss') as starttime ,substr(a.starttime,1,4) as year,substr(a.starttime,1,7) as month, substr(a.starttime,1,10) as... 阅读全文
摘要:
SSRS Drillthrough for SSAS cubes, how to pass a parameter to an MDX dataset Yesterday I had a chat with my boss about drillthrough reports. I told him that with SSRS 2008 it can be done easily. Yep, I... 阅读全文
摘要:
BuiltinAdminsAreServerAdmins is a server property in Analysis Services which is set to true by default as shown in the figure below.What this means is, all the local administrators on your windows mac... 阅读全文
摘要:
Eric JohnsonMy Thoughts on SQL Server and Database Related Technologies.Understanding the SSIS Package Protection Level One property of all SSIS packages that you must understand is the ProtectionLeve... 阅读全文