window| E-commerce | design | Scaling Now, we use this data in an OLAP cube so that we can analyze it more dynamically, and we can use it in other programs such as Excel. Since the introduction of the use in the last demo is complete, all we have to do is synthesize the tables for the OLAP process and use those cube data.
The first thing we have to do is we have to go to the results server and then Query Analyzer. Once it's turned on, we're going to use a script. We went to the file and opened it, and then we used the UA plus script file. UA Plus underline script, the underlined file is the one we want to open.
The thing to do now is to populate the cube with all the data. I'll change it into my UA database and run it. Now, as it runs, you're executing a batch query, Shangbaira, creating a table, and moving all of the data from the table to the cube. You can see that when it does, it updates all the DBO information and all the different fields.
It's done now. Once it's done, we can go ahead and close the Query Analyzer, and that's all we've done with it. Now we open OLAP Manager in the program, then sequel Server 7.0 and OLAP Services and OLAP Manager.
We are now moving the data into the cube. We have moved it to the data structure in the last setup, and after we have introduced it through the use of the tool import. Now what we're going to do is actually move it directly into our OLAP cube.
We click it on the OLAP server and then expand our actual server. Under our UA plus template, this template is the database structure we're working with, and we have a cube section.
We clicked on it and then clicked on each one that was defined in a process we were not prepared to involve in this demo, but they have been defined. Now all we have to do is right click on our cube and then select the process, and a dialog box appears, which is actually the first screen of the wizard. We click on the process and then click Okey.
This actually brings the data in the structure into the cube and is now well done. You can see a complete snitch here and click Okey and Close. Good.
Now that we've moved it into the cube, we're going to go into Excel and use that cube. Remember now that it can be any Office program that uses OLAP cubes, Crystal Reports, Excel, and any use of OLAP cubes. Here we use Excel because Excel is a good program for PivotTable reports, which is exactly what we want to use.
Now we're in Excel, we come to the Data menu and then select Pivot Table/pivot Chart. Then we select the external data because we want to look at an OLAP cube and then click Next.
Now note that it says no data fields have been retrieved and we've got the data. We clicked get data and got 3 tags, one of which is OLAP cubes. In the OLAP cube, we have defined what was previously used, called the activity by year.
I want to use the new data resource. I click Okey, which allows us to define a new data resource for this particular PivotTable report. Next, I'm going to use the activity by the hour. Use activity by the hour. I want to select an OLAP provider for the database you want to enter.
And, here, we have only one option. That is the OLAP DB provider for OLAP Services. I click Connect and type the server name. Then click on the Next,ua Plus underline template. I then clicked finish and now I'm connected to my data structure, which means that in this drop-down box, I can see all the cube definitions in the data structure, and I actually did.
Activity by hour is what we want to choose. Click on it, then click Okey. Click Okey here and then you can notice it says the data field has been retrieved and the Next button is activated, so I click Next, which takes us to the last part of the Pivot Table in Chart Wizard, which is the third step of the third part. Here we get a selected cell. Put it into this existing worksheet and follow our choices. We can, however, select a new worksheet. I'm going to click Finish and then I'll create the pivot table.
Now, the pivot table appears and basically it's just a placeholder for the data we want to move into with the cube. Now, remember that each of these is actually one dimension of the cube, and we move forward and pull the data to move it row the field section. Next is our year and the information about the columns that will be defined by the year information.
We can also pull out the hours and enter them into the row fields. Now our line is defined by the hour. Then, in the data structure body, we place the request and the access. Now, for the second visit, you actually have to refer to it for the first time. Now we have a request and a visit.
This is a basic pivot datasheet. It displays the cube information. One advantage of cube information is that we can use the same dimensions of different fields and expand it by clicking 1998来. Now, if you have a different year, this will show more years and if you split it in months, it will show more months. But our record data does not have this item, so the specific data shown is 1998.
Another way to make more restrictions is to have a data structure here, I click on this small downward arrow, and now it shows the dimensions of the request and access I'm making. I will turn off the request and then click Okey and notice that the access is only displayed now.
Now we notice that there is a number of minutes of information, because that is a detail part, I can show or hide it. I can get this information down here.
Well, that's good and useful, and I can add more to it in the context of most pivot data tables. I can insert a page field. But I'm going to take two or more steps to move it. I'm going to create a chart from it. I clicked on the Chart Wizard in the pivot chart bar and entered a very simple chart.
Because, as you can see, the data is fairly straightforward, and I'm going to change it to two different chart forms. I'm going to change it to a linear chart, and that's it. Now that I have a chart and my perspective chart information, if I go to worksheet 1, I can see the pivot Chart information and in worksheet 1 you can see the diagram. And it's the same in our Excel.
But what we're going to do is save it as a Web page. This requires more additional functionality for Office 2000. Since we've expanded with OLAP Services, we get the report information, move it dynamically into Excel, and we've checked and changed it.
Now all we have to do is check and create a new HTML file based on this pivot datasheet. So I choose the diagram. The picture appeared thereupon. I'm going to add an internal activity and you'll see what it does in 1 minutes.
I'm going to talk about hour activity now. Click Save this will produce HTML, just like that. I'm going to open Internet Explorer and raise level two up. It's in my folder and you can put it anywhere.
Here is the report you just created. Note that my table data and below are my OLAP information. The interesting thing about OLAP information is that if you want to know, please note that in 4, 5 and 6 hours, there are no very detailed details. There is virtually no change there. You'll notice that it's kind of like a horizontal line off the border.
I clicked the arrow on the right. Note that this is in the Web page. I will choose 4, 5 and 6, turn them off, click Okey, and my diagram is automatically updated. This is the internal activity we want to store. This is the same as the year. If I don't want to show a particular year, I can go ahead and do it.
I can do some other work here, including refreshing the data and outputting it from here to Excel. I can look at the attributes from here, see the field list for it. But all of this will be done within the HTML page. That shows scalability.
We introduce the initial folder usage and get the data, and we move it into the cube. From these cubes, we then go into Excel, use that cube data, open a Pivot data table, create a diagram in the pivot datasheet, and store the pivot datasheet and graph as a Dynamic HTML folder. Now, finally, we can manipulate this information by doing business information or even Web pages for intranet information.
So, in this demo, you can see how to use the extended feature of UA Plus to get a better analysis of your record data than using OLAP and OLAP Services, and then publish a fully interactive Web page that uses the report data. Then move to the right back to the PowerPoint slide.
So, to our conclusion. Will produce an upgradeable, usable, and trustworthy Web site. Well, first of all, you have to understand your model. Are you a commercial website? Are you a Intraner website? Are you an E-commerce site with lots of deals but no search?
Then you have to be sure that you have tested, tested, and tested your system, using things like network application focus tools (Web application strength test tools). In addition, there are other tools that allow you to do the work.
Network key tools are easy to use. can optimize your system. Don't forget that even though it's a Web server, it's still a win server or win NT server and remember that you can optimize your system in the same way that you optimize orphaned servers.
Protect your system because you can have the best sites, the most scalable, most available. If a hacker attacks you, your system will be destroyed and you may lose money.
Go ahead and analyze your results because you are the way you can tell what you are doing is useful or useless. Analyze the attacks against you. Analyze attack time, where they come from and are using those attachments.
And keep in mind, like any good method, you need to repeat. So if you need more information, you might want to refer to the TechNet URL, which is its URLs. You may want to refer to the Microsoft formal tutorial. It also has the technology Center technology centers on Windows 2000 on the TechNet Web site, in two win 2000 links. This business web site has a good message about a business Server. This secure Web site has good security information.
Finally, you have an IT professional user group in your specific area that you can find in the Web to the TechNet user group.
I'm the author, Jim Osborne. The publisher/editor is Ken Kubota. A large number of people have previewed and reviewed this section in this field. Thank them.