ssas
Ensemble classifiers (Random Forest, Bagging, Boosting, etc.) in SSAS
I am using SSAS (SQL Server 2008 R2) to develop a classification model for a data set where 80% of values are missing. Ensemble classifiers based on trees are supposedly the best solution (Random Fore[详细]
2023-03-09 13:56 分类:问答SQL Server Analysis Services 2005 the instance was not found on the server
Named instance of SSAS 2005. I can ping the machine by name, IP, and FQDN. I can RDP to the machine. I\'ve tried swapping out service accounts, and of course restarting SSAS multiple times. Using the[详细]
2023-03-09 06:33 分类:问答MDX query "with member" and sum problem
I have a query like WITH MEMBER [measures].[Count] AS SUM(([Location].[Hierarchy].[Zone].[1].Children),[Measures].[Length])[详细]
2023-03-08 06:49 分类:问答Can I use TSQL to query an OLAP database or is MDX required?
I\'m reading a little into data warehouses and OLAP DBs and it\'s a little unclear if I have to learn MDX to be able to query OLAP databases. Secondly, is开发者_运维百科 SSMS the tool used for queryin[详细]
2023-03-08 04:40 分类:问答Connecting SSAS to Teradata
I have been building cubes for the last six month and was doing well until I was approached with a new task. This new task was to setup a cube that uses Teradata as it\'s data source so I get to build[详细]
2023-03-06 17:48 分类:问答Cursor in a MDX expression?
I have a TABLE A( Type INT, Value INT ) Now I want to calculate the difference between the Value of each two subsequent lines of the same Type.[详细]
2023-03-06 12:47 分类:问答Operational database schema to data mart schema, table reduction?
I\'m starting to study SQL Server Analysis Services and I\'m working my way through the training book, as well as the Developer Training Kit. In both, I find suggestions that the number of tables used[详细]
2023-03-06 12:10 分类:问答Analysis services project lifecycle
Is there a standard via which one should start an analysis services project? Out situation is that we work locally on our machines, and the relational DB is out of our domain - and the server that ana[详细]
2023-03-06 06:39 分类:问答Include Empty Values in SSAS MDX query to use in SSRS
I have a cube derived from one fact table that has a key and three other attributes fact_event (eventid, ageband, location, type)[详细]
2023-03-05 03:50 分类:问答One to many Relationship in SQL Server Analysis Services
I have these tables: DimDate (PK: DateKey, other attributes) FactActivationCodes (PK: ActivationCode, IssuedDateKey (FK to DimDate)[详细]
2023-03-04 04:29 分类:问答