MSI MS-96E0- Manuals

Page 2 - Test connection failed because; File; allowing to know what is the

2 Click&DECiDE NSI & BAI | KBA www.clickndecide.com Contact us: E-mail: [email protected] Tel: +33 (0)6 71 99 86 60 Sales Offices: 98, route de la Reine - 92100 Boulogne-Bt, France. To contact your nearest Click&DECiDE partner, click here . If you have a client PC that want to creat...

Page 3 - If the; Microsoft OLE DB Provider for Analysis Services 9.0; is missing, here is the way to install it:; Steps 1; Click; Download file; below and select the; Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider

3 Click&DECiDE NSI & BAI | KBA www.clickndecide.com Contact us: E-mail: [email protected] Tel: +33 (0)6 71 99 86 60 Sales Offices: 98, route de la Reine - 92100 Boulogne-Bt, France. To contact your nearest Click&DECiDE partner, click here . If the Microsoft OLE DB Provider for Analy...

Page 4 - Show SQL Cube; option: start Click&DECiDE Builder and run the command; Tools; Create a new cube from an existing query:

4 Click&DECiDE NSI & BAI | KBA www.clickndecide.com Contact us: E-mail: [email protected] Tel: +33 (0)6 71 99 86 60 Sales Offices: 98, route de la Reine - 92100 Boulogne-Bt, France. To contact your nearest Click&DECiDE partner, click here . Cube Debug: Sometimes the Click&DECiDE...

Page 5 - Select the required Dimension and Measures:; Finish; Specify the parameter values if needed, then click; OK

5 Click&DECiDE NSI & BAI | KBA www.clickndecide.com Contact us: E-mail: [email protected] Tel: +33 (0)6 71 99 86 60 Sales Offices: 98, route de la Reine - 92100 Boulogne-Bt, France. To contact your nearest Click&DECiDE partner, click here . The reason is that the Show SQL Cube Optio...

Page 6 - uncheck the “Delete Temporary File” option. Then click

6 Click&DECiDE NSI & BAI | KBA www.clickndecide.com Contact us: E-mail: [email protected] Tel: +33 (0)6 71 99 86 60 Sales Offices: 98, route de la Reine - 92100 Boulogne-Bt, France. To contact your nearest Click&DECiDE partner, click here . 8. Make a copy of the SQL content of the a...

Page 7 - ODBC Setup

7 Click&DECiDE NSI & BAI | KBA www.clickndecide.com Contact us: E-mail: [email protected] Tel: +33 (0)6 71 99 86 60 Sales Offices: 98, route de la Reine - 92100 Boulogne-Bt, France. To contact your nearest Click&DECiDE partner, click here . - Click OK - Click ODBC Setup

Page 8 - Select; System DSN

8 Click&DECiDE NSI & BAI | KBA www.clickndecide.com Contact us: E-mail: [email protected] Tel: +33 (0)6 71 99 86 60 Sales Offices: 98, route de la Reine - 92100 Boulogne-Bt, France. To contact your nearest Click&DECiDE partner, click here . - - Select System DSN - Click Add and sear...

Page 9 - Enter a; Data Source Name; Uncheck; Use Current Directory; and click; Select Directory

9 Click&DECiDE NSI & BAI | KBA www.clickndecide.com Contact us: E-mail: [email protected] Tel: +33 (0)6 71 99 86 60 Sales Offices: 98, route de la Reine - 92100 Boulogne-Bt, France. To contact your nearest Click&DECiDE partner, click here . - Click Finish - Enter a Data Source Name ...

Page 10 - Search for the path by default; This new Data Source Name should appear in the

10 Click&DECiDE NSI & BAI | KBA www.clickndecide.com Contact us: E-mail: [email protected] Tel: +33 (0)6 71 99 86 60 Sales Offices: 98, route de la Reine - 92100 Boulogne-Bt, France. To contact your nearest Click&DECiDE partner, click here . - Search for the path by default C:\Progr...

Page 11 - and select the; TestCSV; system data source in the; ODBC Data Source; The ODBC Data Source should display as follow:

11 Click&DECiDE NSI & BAI | KBA www.clickndecide.com Contact us: E-mail: [email protected] Tel: +33 (0)6 71 99 86 60 Sales Offices: 98, route de la Reine - 92100 Boulogne-Bt, France. To contact your nearest Click&DECiDE partner, click here . - Click OK and select the TestCSV system ...

Page 12 - Right click and select; Test Connection; Make a new Query and select the

12 Click&DECiDE NSI & BAI | KBA www.clickndecide.com Contact us: E-mail: [email protected] Tel: +33 (0)6 71 99 86 60 Sales Offices: 98, route de la Reine - 92100 Boulogne-Bt, France. To contact your nearest Click&DECiDE partner, click here . - Click OK - Right click and select Test ...

Page 13 - Enter no login and click; Click the; Run; If you get no error, the Microsoft ODBC Text Driver is working fine.

13 Click&DECiDE NSI & BAI | KBA www.clickndecide.com Contact us: E-mail: [email protected] Tel: +33 (0)6 71 99 86 60 Sales Offices: 98, route de la Reine - 92100 Boulogne-Bt, France. To contact your nearest Click&DECiDE partner, click here . - Enter no login and click OK - Select a ...