Hi, I'm trying to learn about analysis, integration and reporting services. I have install SQL server 2005 management Studio Express. but I cant find these in the Start menu as mentioned in the tutorial Click Start > SQL Server 2005 > Business Intelligence Development Studio.(for reporting services). what do I need to do? Please help me.
I downloaded a trial version of office 2007 and the data mining addin. I do not have an automatic connection to Analysis Services, so most functionality does not work. Is it possible to configure a connection with a trial version? If so, does anyone know what the server name is and how to configure it?
A rather dumb question but I've installed an evaluation copy of SQL 2005 on my machine and a colleague would like the Analysis Services Data Mining capability on his machine (without the eval SQL Server).
Is there a license associated with such an installation when we buy 2005 or does it fall under client components which can be installed on any number of users machines?
How to right choose key column in"Mining Structure" for Microsoft Analysis Services?
I have table:
"Incoming goods"
Create table Income ( ID int not null identity(1, 1) [Date] datetime not null, GoodID int not null, PriceDeliver decimal(18, 2) not null, PriceSalse decimal(18, 2) not null, CONSTRAINT PK_ Income PRIMARY KEY CLUSTERED (ID), CONSTRAINT FK_IncomeGood foreign key (GoodID) references dbo.Goods ( ID ) )
I'm trying to build a relationship(regression) between “Price Sale” from Good and “Price Deliver”.But I do not know what column better choose as “key column”: ID or GoodID ?
I have some questions about SQL Servers 2000 and 2005 compatibility. In my configuration I have to use both servers. The cubes are stocked in 2005 server. May I transfer from 2005 to 2000 Analysis Services the cubes?
If yes, what is the procedure? The result of migration is the same in the two different versions?
hi I am new at MSSQL 2000 DBA thing. and trying to learn more about analysis service/data warehouse/data mining. so is any expert out there can Recommend some good books or web link article to read? Thanks
I am wondering if it is possible to use SSIS to sample data set to training set and test set directly to my data mining models without saving them somewhere as occupying too much space? Really need guidance for that.
I am wondering where can I store my mining results in data mining engine? For example, I got mining results like accuracy chart, decision trees, and other formats of results based on different mining algorithms I used for my data mining, so where can I actually store the results for reporting service use later? Is it possible to do that in SQL Server 2005?
Thanks a lot for any help and guidance in advance.
I'm trying to create reports in RS2005 using AS2000 as my data source. I understand that if I use RS2005 on AS2000, I wont be able to enjoy the OLAP based parameters as in using AS2005. Does anyone know an easy way to easily use Parameters in RS2005 while still using AS2000?
i have a small problem with the data sources in the reporting services, maybe you can clarify the situation... I have a MS CRM 3 solution with the reporting services 2005 installed. From an other vendor we have a arcplan solution on the 2000 analysis services. I would like to get access from the 2005 reporting services to the 2000 cube. Is this possible? Ive read that the SSMS cant connect to the 2000 cubes. Can i connect from the reporting services??
i want show other products when somebody choose a product, ect: product1 product2 A B, C ,D B C,D,E C F, G ....... i create model: I create a mining model: CREATE MINING MODEL [bh'S] ([Cusid] LONG KEY , [Products] TABLE PREDICT ([Productid] LONG KEY )) USING Microsoft_Decision_Trees
INSERT INTO [bh'S] (SKIP, [Products] (SKIP, [Productid])) SHAPE {OPENROWSET(, 'SELECT DISTINCT "dbo"."customers"."cusid" AS "Cusid" FROM "dbo"."customers" ORDER BY "dbo"."customers"."cusid"')} APPEND ( {OPENROWSET(, 'SELECT DISTINCT "dbo"."orderdata"."cusid" AS "UI_GENERATED_PARENT_KEY_COLUMN", "dbo"."products"."productid" AS "Productid" FROM "dbo"."orderdata", "dbo"."orderdetails", "dbo"."products" WHERE (("dbo"."orderdata"."orderid"="dbo"."orderdetails"."orderid") AND ("dbo"."orderdetails"."productid"="dbo"."products"."productid")) ORDER BY "dbo"."orderdata"."cusid"')} RELATE [Cusid] TO [UI_GENERATED_PARENT_KEY_COLUMN]) AS [Products]
I use DTS to select data: SELECT FLATTENED [T1].[Cusid] AS PRODUCTID ,topcount(PREDICT ( [bh].[Products],INCLUDE_STATISTICS),$probability,5) AS ReProductid FROM [bh] PREDICTION JOIN SHAPE { OPENROWSET ( ,'SELECT "productid" AS "Cusid" FROM "products" ORDER BY "productid"' ) } APPEND ( { OPENROWSET ( ,'SELECT "productid" AS "Cusid_1", "productid" AS "Productid" FROM "products" ORDER BY "productid"' ) } RELATE [Cusid] TO [Cusid_1] ) AS [Products] AS [T1] ON [bh].[Cusid] = [T1].[Cusid] AND [bh].[Products].[Productid] = [T1].[Products].[Productid]
My result productid1 productid2 1 2372 1 5422 1 1223 ... 2 2372 2 5422 2 1223 ..... 3 2372 3 5422 3 1223 ... how can i do ? i can't write predicts(products,5) or predicts([model name].[products],5) . when i run -> error
How can I use reporting services to get reports out of analysis Services Database ?
I found following on one site, but I tried to look for Analysis services database on the server I am deploying the model , but I am not able to find it.
'To use Reporting Services with data mining, you simply create a Reporting Services project with the BI Dev Studio and specify an Analysis Services database as your data source. Depending on the contents of the database, you will be presented with either an OLAP or Data Mining query builder as in Figure 3.23. You can always switch between the two modes by clicking the Switch '
I have a cube with 20 dimensions. I have two dimensions with more than one million of members. When I process these dimensions Analysis Services 2000 create files with "axis" extension. What are these files? Why, when I start MSSQLServerOLAPService or when I process another cube in another OLAP database, these files sre updated?
I have a problem with Microsoft Analysis services, we already configure the boot.ini and the registry to use 3GB in RAM, but 2 or 3 times in a day we should restart the services to clean the memory, as you can see thats not acceptable. The application that use the OLAP is OutlookSoft . Here the scenery SO. Windows Server 2003 Enterprise Edition with SP 1 RAM 4 GB Analysis services 2000 with SP 4
Hi, I've created an SSIS package to process cubes on Analysis Services 2005. This works fine.
Now I wish to use the same package to run Cubes on Analysis 2000. I have changed My connection manager to point to this DB. When I test connection it works fine.
The problem lies, when I try to edit the Analysis Service Processing Task. I get an error message saying: "A connection cannot be made-Make sure the server is running".
I can get into Analysis Manager ok, and see the database there.
Hope someone can point me in the right direction here?
How do I connect to an Analysis Services 2000 cube while in Integration Services? My idea is to execute an MDX query from within a package, and then stage the data to a SS 2005 table for a RS report to query.
I recently started using SQL 2000 Analysis Manager. I wanted to try data mining but was unable to get the Mining Model Wizard to load available techniques.
When I select a cube and "New Mining Model" I get the following error:
"Unable to get list of data mining algorithms."
"Object of provider is not capable of performing requested operation"
I've got a software development PC that was running SQL 2000 + Analysis Services + Reporting Service (sp4 from memory). I then installed SQL Express 2005 and later then SQL 2005 Standard (dev) + Analysis + Reporting and upgraded to Sp2 last month.
To help improve the performance of this poor little PC, I've gone to Control Panel and uninstalled SQL 2000 service. I've also used the SQL 2005 Surface area configuration tool to switch off the SQL Express instance from running. Practically, I probably should remove the $SQLExpress instance.
The problem I'm faced with is the SQL 2000 Analysis and SQL 2000 Reporting service is still registered as Windows Services and showing the the SQL Server Configuration Manager (2005), but there is no uninstall option in the control pannel. So I can't work out how to uninstall these software and services.
It is also apparent that there are a series of "files" in the C:Program FilesMicrosoft SQL Server80* directory like ..ToolsDevToolssamples*.* directory and others that shouldn't really be there if I've uninstalled SQL 2000 via the control panel.
Is there a SQL 2000 cleanup or removal tool that will help remove these old services and files?
Does anyone have some suggestions on how to cleanup my development PC without the full operating system installation?
I would like to know if there is any way to migrate third-party data mining packages with SQL Server 2005 data mining algorithms together then we can have a comparison among all of them to get the best results for training models.
Hoping someone will have a solution for this error
Errors in the metadata manager. The data type of the '~CaseDetail ~MG-Fact Voic~6' measure must be the same as its source data type. This is because the aggregate function is not set to count or distinct count.
Is the problem due to the data type of the column used in the mining structure is Long, and the underlying field in the cube has a type of BigInt,or am I barking up the wrong tree?
I'm a beginner with SQL 2012 SSDT & SSMS. I get this error message when I try to deploy my project:
"Error 6 Error (Data mining): KEY SEQUENCE columns are not supported at the case level. The 'Customer Key' column of the 'TK448 Ch09 Cube Clustering' mining structure contains content that is not valid. 0 0 " I am finding it hard to locate the content that is not valid. I've been trying to find a answer for this problem but can't seem to find anything. How can I locate the content that is not valid and change or delete it so that I can deploy this solution?
- a data mining structure with about 80 columns. - a data mining model using Microsoft_Decision_Trees with 2 prediction columns.
I thought I would then explore the possibility of have more than 2 prediction columns, in this case 20.
I get an error message and I can't work out : a) if this is because there's a limit to the maximum number of prediction columns and where that maximum is stated. b) if something else has become corrupted c) there's a know bug and if the error message is either meaningful or not.
Either way, I'm unable to complete the data mining wizard
The error message is :Errors in the metadata manager. Either the mining structure with the ID of '[my model Structure]' does not exist in the database with the ID of 'DMAddinsDB', or the user does not have permissions to access the object.
I am using Microsoft_Time_Series and have set HISTORIC_MODEL_GAP to various values (from 1 to 21). I always get this error: Error (Data mining): The 'HISTORIC_MODEL_GAP' data mining parameter is not valid for the 'My Time Series' model.
In Algorithm Parameters window, this parameters is not there by default, so I have to add it.
Implementing data mining Add-in in an academic setting? We need to handle over 150 new students a semester and have their connection to Analysis Services survive for their four years at the college. We are introducing data mining to every freshman business student as a unit within their Intro to Excel class (close to a month of work to give them a sense of what is possible). Other courses later in their curriculum will expand on that introduction.
Once implemented, we would have as many as 900 connections to manage (four years from now). It is possible that multiple sections will be running at the same time, so 40 students may be accessing the data mining tools concurrently.
Is there a way to "bulk establish" the access credentials and establish those databases?
Would please any expert here give me any guidance about what Data Mining tasks can be automated and scheduled via Integration Services Packages? Also, If we automated the tasks, can we also automatically save the results of the tasks somewhere? Like if we automate assessing the accuracy of a mining model, then we wanna know the mining model accuracy later, therefore, we need to save all these results from the automated actions. Is it possible to realize this?
Thanks a lot in advance for any guidance and help for this.
With SASS Database i have created Data mining Structure Using Time series algorithm, while processing the SSAS db, Data mining taking long time to process, so how we can reduce processing time ???
