Notes on 3rd Day Training

Christopher Richard - Is the faculty for this training

MDX - Multi Dimension eXpression

MDX is a Key to all advanced functionality in Analysis Server

JimRoy Number -- ?

Books To Read to get to know more in detail about OLAPDM -

1) Datawarehouse Toolkit, A complete guide for DM - Ralf Kimble,
Willy Pubs

2) MDX - MDX Solutions for SQL2005 and HyperonSpace - George Spafford,
Willy pubs

Difinitions in OLAP

Slice - Members of one dimension
Dice - Members of more than one dimension display

A Cube can have upto 128 DimensionsMDX can have upto 64 Axes

While fetching the Level name can't preccede the member name

MDX Query
Example
1) select {[Measures].[Order Quantity], [Measures].[Sales Revenue]} on
columns, {[product].[categories].[bikes]} on rows from [quick start
sales view]

Result:
OrderQuantity Sales Revenue
Bikes 90268 94651172.7047148

2) select {[Measures].[Order Quantity], [Measures].[Sales Revenue]} on
columns,
{([product].[categories].[bikes]),([product].[categories].[clothing])}
on rows from [quick start sales view]

Result:
OrderQuantity Sales Revenue
Bikes 90268 94651172.7047148
Clothing 73670 2120542.524801

Note: When you are using more than one member one has to use "()" to
put each member and seperate them by ","

3) select {[Measures].[Order Quantity], [Measures].[Sales Revenue]} on
columns, {[product].[categories].[product category].members} on rows
from [quick start sales view]

Result:
OrderQuantity Sales Revenue
Bikes 90268 94651172.7047148
Components 4904 11802593.2864
Clothing 73670 2120542.524801
Accessories 8654 21586524.484
Unknonw null null

4) select {[Measures].[Order Quantity], [Measures].[Sales Revenue]} on
columns, {[product].[categories].[product category].members} on rows
from [quick start sales view] where [time
dimension].[calendar].[calendar 2001]

Result:
OrderQuantity Sales Revenue
Bikes 20268 4651172.7047148
Components 1904 1802593.2864
Clothing 11670 120542.524801
Accessories 4654 1586524.484
Unknonw null null

Note: this data is for a single calendar year by using the WHERE Clause

KPI - KeyPerformanceIndicator - Why they are at backend, they are
supposed to be at frontface as they are similar to Dashboard.

Note: These exists from quite a long time in the industry, but are new
from Microsoft's pespective and for the first time they have included
them in their product

MicroSoft Dashboard Manager or KPI Manager

Scorecard - is the information that is WRT other information
DrillThrough - Is another feature that every OLAP tool should support.

MLOP - Is the +vesFastest storage ModeRetrival is Fast-ve is Latency

RLOP - will only create the Cube and the data is still there in RDBMS

HOLAP - Details data is still there in RDBMS, where as Aggrigates are
stored at Dimensional Model, inotherwords, in Cubes

Problem:
Your client has a cube that is set to process for every 2 hrs
Solution:
?????


-----------------------
If you have something to share in person on this post, pl drop me a mail at dskcheck@gmail.com with the title in the subject.

Comments

Post a Comment

Popular posts from this blog

Network Intrusion Detection using Supervised ML technique

Declaimer This is my initial version of the synopsis for PhD studies. There are plenty of things that i have to complete before i prepare the final version. Thus, this would be the alpha version. Due to the length of the blog post, will not be posting the entire draft. 1.Title of the thesis Network Intrusion Detection using Supervised Machine Learning Technique with Feature Selection 2.Introduction Intrusion Detection System, IDS, is a development which improve the network security and defending the information of the association. The IDS encourage the network chairman to recognize any malicious action on the network and alarms the executive to get the information made sure about by taking the appropriate activities against those attacks. An intrusion alludes to any unauthorized access or malicious usage of data assets. An intruder or an attacker is a true element that attempts to discover a way to increase unauthorized access to data, causes hurt or take part in different
Read more

Common mistakes by Interviewer

Now-a-days am conducting few interviews for our organization. While sitting in the other side of the table, I've visualized why most of the interviews fail with me. But when conducting these interviews, most of the candidates are attending with self confidence that they are suitable for the mentioned role and attend without preparation. When people do some real preparation, they tend to fail due to lack of awareness at the interviewer towards interviewing techniques. Having failed in many interviews, I've learned that the interviews fail because of the following... Reflection (or) Mirroring: The interviewer tends to see self within the candidate. The interviewer starts to compare self with the candidate and evaluate. This evaluation is totally personal. The yard stick for measuring the candidature is not generalized, but influenced.   Template (or) Checklist: The interviewer has a template of a questionnaire. The interviewer measures the candidate with respect to the list of st
Read more

Keep the system active, to avoid the auto lock

Most of the corporate offices will have a policy for screen locking. While working with a long running applications at background, like the automation scripts for testing the applications, it would be difficult to maintain the unlock state of the screen. Thus, we found a technique to keep the system active with a cheating technique. Below is the powershall scripts that keeps the system active ' I am clicking on NUMLOCK for every 5 seconds to keep the system awake Set objNetwork = CreateObject("Wscript.Network")'to get user name numOfHours=inputbox("Hi " & objNetwork.UserName & ", How many hours you want me to be awake? :->") 'time variable conatins the time in hours Set WshShell = WScript.CreateObject("WScript.Shell") 'Creating an object for clicking keys from keyboard numOfMilliSecs=numOfHours*3600*1000 'converting hours to milli seconds While numOfMilliSecs>0 'runs until tym becomes zero WshShell.Send
Read more