| Author |
Topic |
|
j_robertraj
Starting Member
9 Posts |
 Posted - 2002-04-22 : 06:26:11
|
| I want to develop One OLAP product to analyse the data.Main objective of the project is the users of the system are located in various locations.What the superuser will he will submit the set of Questions to the system ,those you are registered to system ie normal user ,they will submit the answers.Main analysis I am going to do is how they answered the questions compare to other questions based on various locations.I don't know the abc of OLAP and Analysis Server.What I have to do for this.kindly help me what are the things i have to do to develop the system. |
|
|
sandesh_moghe
Constraint Violating Yak Guru
310 Posts |
Posted - 2002-04-22 : 06:36:47
|
| Yes,Its quite possible.Can you please specify your networking Archietecture in details?Means about Locations, Superusers and Users.Where the database is residing?Are you using any front end? like VB---------------------------Sandesh - The Messanger |
 |
|
|
j_robertraj
Starting Member
9 Posts |
Posted - 2002-04-22 : 07:30:52
|
| Thanks a lot for immediate response Sandesh.The application I am talking about is web based application developed in ASP.NET application.The location I told my last is when the user registering into this application he will be entering which area he belongs.Regarding my network style web server and database server located in remote places we got the space from server providers who loacted in USA.My Front end going to be ASP.NET,VB.NETEdited by - j_robertraj on 04/22/2002 07:35:31 |
|
|
|
sandesh_moghe
Constraint Violating Yak Guru
310 Posts |
Posted - 2002-04-22 : 09:01:15
|
| Hi Robert,You have the database in US, and where the Superuser is sitting? At your place or at remote server?See, traditionally the database which is used for OLAP must be non transactional.It affects the speed. If in your product the transactions are less then you can do that.First of all You have to select the fact table which your QuestionAnswer table.You have to specify the dimensions (Such as Location, AgeGroup etc....)And can create multidimensional cubes.---------------------------Sandesh - The Messanger |
|
|
|
j_robertraj
Starting Member
9 Posts |
Posted - 2002-04-22 : 15:12:15
|
| Thanks Sandesh,The super user will sit and do the analysis in my place using the Front end I am going to develop using ASP.NET.First of all I don't know what are the setup I have to do.I know little before doing data analysis I have to tansfer data from OLTP server to OLAP server.Is it possible both the server in same machine.How can I tranfer the data from OLTP to OLAP server if I am runnig different server for OLAP services?.Once tansfer the data what I have to do people saying that i have to create Cubes and MDX quesry can you kindly suggest some book to know all this. |
|
|
|
sandesh_moghe
Constraint Violating Yak Guru
310 Posts |
Posted - 2002-04-23 : 01:06:49
|
Robert,You have to set Analysis Server (If you are working on SQL Server 2000)Yes you can have Analysis Server and OLTP Server on same machine.(In SQL Server 2000 OLAP services is called as Analysis services).But if on OLTP server heavy transactions are there then you have to choose the separate server for Analysis, else it will affect the performance of Transactions.You can you DTS of SQL Server for transfering Data from OLTP server to OLAP server.In DTS you can Transfer Data to Remote Server also.Yes, For representation of Analysed data you have to Create Cubes or MDX Queries, which you can handle with ASP.NetAs per my knowledge, Step By Step Analysis Services, By Microsoft Publication is the best book.[url]http://www.softpro.com/0-7356-0904-7.html[/url] ---------------------------Sandesh - The Messanger |
|
|
|
j_robertraj
Starting Member
9 Posts |
Posted - 2002-04-23 : 07:00:23
|
| Hi Sandesh, Thanks a lot for your valuable information.Kindly help me out on this case.I am planning to have two server one for OLTP and other one for OLAP.To setup this what have to do,I think i have to install Sql Server 2000 Server version in two machines on that one Server without Analysis Services component is it right. |
|
|
|
sandesh_moghe
Constraint Violating Yak Guru
310 Posts |
Posted - 2002-04-23 : 07:19:20
|
| Robert,Yes you have to install Analysis server only on OLAP Server.Also Do following things1. Schedule DTS from OLTP server to OLAP server when the transaction density is less (Probably at 00:00 AM)2. Create Data Source, Database, Fact Table, Dimensions, Measures3. Create Cube4. Use this Cube in the Front End.---------------------------Sandesh - The Messanger |
|
|
|
j_robertraj
Starting Member
9 Posts |
Posted - 2002-04-23 : 08:47:42
|
| Hi Sandesh, Thank you for your kind help ,I have installed Sql Server and Analyser Server as you said.But when I am creating DataSource which server I have to mention in DataSource whether OLAP server or OLTP Server.If I mentioning OLTP server name in DataSource field why I have to transfer the data using DTS. |
|
|
|
sandesh_moghe
Constraint Violating Yak Guru
310 Posts |
Posted - 2002-04-23 : 08:55:51
|
| No,First of all you have to DTS the database from OLTP Server to OLAP Server.If you are not regular user of the Data Transfer, then use DTS Wizard.DataSource is used during creation of the Cube.---------------------------Sandesh - The Messanger |
|
|
|
j_robertraj
Starting Member
9 Posts |
Posted - 2002-04-23 : 09:42:20
|
| Hi Sandesh, I feel I am bugging you too much ,but thank you for your patients.What confusion I am having right now is.When I am creating the Datasource in Analysis Server I have to mention the name of the server ,what should be the name of the server OLTP server name or OLAP server name. |
|
|
|
sandesh_moghe
Constraint Violating Yak Guru
310 Posts |
Posted - 2002-04-23 : 09:55:20
|
| it must be OLAP Server---------------------------Sandesh - The Messanger |
|
|
|
j_robertraj
Starting Member
9 Posts |
Posted - 2002-05-03 : 05:51:35
|
| Is it possible to help me to design the datamart based on my requirements . |
|
|
|
sandesh_moghe
Constraint Violating Yak Guru
310 Posts |
Posted - 2002-05-07 : 07:47:54
|
| Tell me your requirements..will definitely help you, if it is in the limit of my knowledge......---------------------------Sandesh - The Messanger |
|
|
|
j_robertraj
Starting Member
9 Posts |
Posted - 2002-05-08 : 01:38:06
|
| Hi Sandesh, Kindly tell me where you located,I will come and approach you directly or Is it possible for you to work with me for couple of weeks.If you are intrested kindly confirm as soon as possible. |
|
|
|
sandesh_moghe
Constraint Violating Yak Guru
310 Posts |
Posted - 2002-05-08 : 02:39:51
|
| Robert,Right now i am in Pune---------------------------Sandesh - The Messanger |
|
|
|
j_robertraj
Starting Member
9 Posts |
Posted - 2002-05-08 : 02:45:52
|
| Sandesh, I am working in Delhi.Will it possible to come over here to work with me for couple of weeks ie until to finish off database part of this project. 1.Designing DataMart 2.DTS package Creation to Transfer Data between OTLP to OLAP system. 3.CUBE Processing. 4.MDX Queries based on the Requirement.If you are intrested kindly confirm me,rest all after your confirmation. |
|
|
|
sandesh_moghe
Constraint Violating Yak Guru
310 Posts |
Posted - 2002-05-08 : 03:12:35
|
| Robert,Right now i am working with the a HongKong Based company as DBA.Will you please send me info about your Company and Project?You can send it on sandesh_moghe@yahoo.comWaiting for your reply.Thanx---------------------------Sandesh - The Messanger |
|
|
|
|
OLAP Project