MDX Training : Need Review

Apr 13, 2004

Hi Gurus ....

Planning for a MDX Training for me and my development team ...
The following has been proposed for a training course spread over three days ...

I need to know whether this will be enough or should some more things be added on to the same (anything that has been missed)...

I have the option of removing and adding from the list.


Module 1: OLAP Review

OLAP Databases
OLAP Definitions
Warehouse Data Flow

Module 2: MDX Foundations

The Role of MDX
MDX Member Names
Using the Calculated Member Builder
Working with Calculated Members

Module 3: Using MDX Expressions

Displaying Member Information
Displaying Family Tree Relatives
Working with Member Properties
Using Conditional Expressions

Module 4: Retrieving Values from a Cube

Understanding Multidimensional Coordinates
Retrieving a Value from a Cube
Percent of Total Calculations
Growth Calculations

Module 5: Creating Simple MDX Queries

Understanding MDX Query Statements
Creating Simple MDX Query Statements

Module 6: Creating and Manipulating Sets

Using Set Creation Functions
Using Set Manipulation Functions
Using Subquery Set Functions
Working with Dimension Interactions

Module 7: Using Aggregation Functions

Understanding Aggregation Functions
Using Time Set Functions
Calculating a Trend

Module 8: Case Study - Implementing Budget Allocations

Allocating Values from a Grand Total
Allocating Values from a Subtotal
Allocating Values Across Multiple Dimensions

Module 9: Using Calculated Cells



Respose needed urgently since I have to get back to the training team by tomorrow morning

View 8 Replies


ADVERTISEMENT

Please Review This UPDATE Sql Statement For Me

Mar 27, 2008

Thanks for looking at this for me. Here is the SQL Script as it stands so far. 
UPDATE    TableImportHistorySET ImportStopTime = CONVERT(numeric, GETDATE(), 108), Elapsetime = CONVERT(numeric,GETDATE(), 108) - CAST((SELECT TOP 1 ImportStartTime FROM TableImportHistory  WHERE     TableName = 'ARCHRG'ORDER BY DataImportID DESC) AS numeric), Successful = 1WHERE (DataImportID = (SELECT TOP 1 DataImportID AS LastID FROM TableImportHistory WHERE TableName = 'ARCHRG') ORDER BY DataImportID DESC))
The Elapetime update portion of this statement is where I'm getting stuck (if I take it out the statement works) 
I get the error "ERROR converting Data type NVARCHAR to Numeric" I've changed the data type in the Table from numric to varchar, nvarchar, decemial nothing works and not sure what I should set the Starttime and StopTime datatypes in the table to (any suggestions please)
Elapsetime = CONVERT(numeric,GETDATE(), 108) - CAST((SELECT TOP 1 ImportStartTime FROM TableImportHistory  WHERE     TableName = 'ARCHRG'ORDER BY DataImportID DESC) AS numeric) 
Are there better ways to do this statement?
 
Thank you in advance
Rex

View 4 Replies View Related

Getting A SQL Expert To Review SQL Server And DB?

Apr 3, 2007

Hi,

I posted last year when we were having problems with a new SQL box we had moved to here...

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=74650

...we coded round most of the issues and deadlocks and things seemed to improve for quite a while but we have recently run into performance problems again of late.

The CPUs on our SQL box often thrash away at 100% and our ColdFusion website has begun running painfully slow.

Our developers/hosts have suggested we might need to look for a 3rd party SQL guru who could look at the SQL box, do some tracing etc. and perhaps make some recomendations around optimising the DB architecture or changing the way we run certain queries. At the moment we have only gut instinct on which bits of the DB are likely to be being hit most hard.

Our website has grown from being very small to being really quite busy and it's possible we are running into shortcomings with the design of the DB that need to be tackled before we can expand further.

I'm not sure what the protocol is (I see there is a Jobs part of the site) but I wondered about the possibility of getting one of you guys in for a short while to review our server and database, for a fee of course. I'm not sure how long it would take to review that kind of data and get a feel for the usage?

We are based in the UK and whilst I guess it could be done remotely it might be easiest if the person was UK based too.

I'm as much interested in feedback about the idea (it might be not workable/a good idea for example) as I am to people offering their services.

If this post breaks any rules please let me know.

Cheers,

Tem

View 18 Replies View Related

Need Consultant Help For Architecture Review

Dec 18, 2007

Don't know if this is the appropriate forum. I am looking for an experienced SS consultant to review our setup, hardware architecture, recovery plan, and to provide high-level advice moving forward. My company is a CRM hosted software provider with a dynamic, metadata-based product built in Visual Studio 2005. Currently we run on SS 2000, but plan to migrate to SS 2005 or 2008. We anticipate quite a bit of growth and want to make sure that we are on the right path. Let me know if you are interested or know someone who is.

If I should post this elsewhere, let me know.

View 2 Replies View Related

1st Attempt, Designing, Would Like Somebody To Review And Critique It

Jan 23, 2001

Hello

This is my 1st attempt at designing a database, and I have not finished
it completely, but I would like somebody to review and critique for me.
I really don't want to make any mistakes with this and I would appreciate any expertise out there to direct, recommend, suggest improvements and/or changes, PLEASE.

Thank you for considering this,,,if you provide me with your e-mail, I can send you a script.

take care,
~Iris~
:)

View 1 Replies View Related

User Review Database Design

Apr 14, 2008

I involved in redesign a database for hotel review listing. My current hotel datatable below

Hotel
ID
HotelName
Description
Address
TotalRating

If I would like to extend the review feature in details based on each user comments for example
Overall 7
Rooms 6
Services 7
Food 8


Could anyone guide me how could I modify the table or add new table that allow me to do so.
Thank you

View 10 Replies View Related

Review Of DB Design - Normalized, Contraints, Foreign Keys, Etc.

Jul 2, 2004

First of all, this is my initial thread here on dbforums. I come from the land of Broadband Reports and would like to say, Hello fellow DB enthusiasts. :)

I'm not a novice to relational databases (Access MDBs), but new to implementing a db via SQL SERVER (2000 in this case) and using Access Data Projects.

My partial db schema is as follows:

participants
---DID (pk) char(1)
---LID (fk - schools) char(4)
---studentLast varchar(50)
---studentFirst varchar(25)

Sample Data would be
010191M001 | 5671 | SPARKS | JONATHAN
030495F283 | 5671 | DYLAN | CYNTHIA
=====================================

enrollhist (insert/update trigger for enrollactive)
---EID (pk - autonumber) bigint(8)
---EMID (fk - enrollmode) int(4)
---DID (fk - participants) char(10)
---LID (fk - schools) char(4)
---enrollactive bit(1)

Sample Data would be
38173 | 4 | 030495F283 | 9003 | 0
38266 | 3 | 010191M001 | 5671 | 0
39022 | 6 | 030495F283 | 9003 | 0
39036 | 5 | 030495F283 | 9003 | 0
39044 | 4 | 030495F283 | 5671 | 1
39117 | 4 | 010191M001 | 5671 | 1
=====================================

enrollmode
---EMID (pk) int(4)
---mode varchar(25)

Sample Data would be
1 | RECEIVED
2 | WAITING
3 | PENDING
4 | ENROLLED
5 | DROPPED
6 | TRANSFERRED
10 | ORPHANED
11 | DENIED
=====================================

schools
---LID (pk) varchar(4)
---CTID (fk - caltracks) char(1)
---AID (fk - agencies) char(1)
---SDID (fk - schooldist) char(1)
---COID (fk - countydist) char(1)
---sitename varchar(25)
---sitetitle varchar(75)

Sample Data would be
5671 | 3 | 2 | 1 | 4 | ASCOT | ASCOT AVENUE
9003 | 2 | 1 | 4 | 1 | ROWAN | ROWAN AVENUE
2865 | 1 | 3 | 2 | 3 | BRIGHT | BIRDELEE BRIGHT
=====================================

caltracks
---CTID (pk) char(1)
---legend char(4)
---trktitle varchar(15)
---trkcnt int(4)

Sample Data would be
1 | 9030 | 90/30 | 4
2 | CON6 | CONCEPT-6 | 3
3 | SNGL | SINGLE TRACK | 1
=====================================

agencies
---AID (pk) char(1)
---legend varchar(4)
---agencytitle varvhar(50)

Sample Data would be
1 | CRYS | CRYSTAL STAIRS
2 | MAOF | MEXICAN AMERICAN FOUNDATION
3 | PATH | PATHWAYS
4 | CCRC | CHILD CARE RESOURCE CENTER
5 | CHSC | CHILDREN'S HOME SOCIETY OF CALIFORNIA
==========================================

THE REMAINING "FKs" FROM SCHOOL ARE SIMILAR, as is other tables and their relationships. The design of the foreign keys were made using sql and the keyword "REFERENCES" and "FOREIGN KEY."

My questions are: :confused:
(1) Is the use of FK as a Constraint any different than using an INDEX and how?
(2) Should I Alter the Tables to include CASCADING Up/Down?
(3) Are the use of CHARs Ok for the Keys?
(4) Have I over/under-normalized any of the relationships?

View 4 Replies View Related

Creating Company's RDBMS Development Review Group

Feb 22, 2008

Hello,
I've proposed to the head of IT at my organisation to head an database development export group to:
- Provide assistance in improving the performance of existing relational databases
- Provide assistance for the development of new database, e.g. correct construction of indexes; data contention, etc.
- Creation of database development standards
- Enforce the above standards for new databases so that the database is not deployed to production servers until it passes the standards.

I'd really like this to be a success as it should improve our rather crappy databases, basically because the people currently creating the databases don't know much about relational design.

Can anyone please post their experiences of setting something like this up, or working on such an expert group where they work? I'd really like to hear the good and bad experiences and what and (what not) to avoid.

Thanks

View 2 Replies View Related

Is There A Way Using Sqlexpress To Review The Most Recent Set Of Sql Commands Submitted To A Database?

May 18, 2007

is there a way using sqlexpress to review the most recent set of sql commandssubmitted to a database?I remember something about setting up logging in sql server 2000, but don'tsee much about this on google or the news group for 2005.thanksJeff Kish

View 2 Replies View Related

Possible To Restore DB Files On Local Laptop To Review Code

Jun 29, 2015

I have an automation project to review the software. The software is using MSVS2012 and uses DBs from MSSQL2012.  Is it possible to restore the DB files on my local laptop to review the code completed thus far?  If so what other software would I need besides MSQLserver 2012 on my local laptop.   I'm able to use MSSQL server 2012 on my local laptop, but the DBs are on servers. 

View 4 Replies View Related

Please Test My Script To Analyze Table Keys (was Submitted For Your Review...:)

Feb 25, 2005

Here is a script I wrote that analyzes datasets and returns all the minimal composite and unary keys that uniquely identify records. I wrote it because I frequently have to analyze client spreadsheets and non-normalized data tables.

On my desktop server it took about two minutes to analyze 2000 permutations of a table with 50 columns and 5000 records.

Please try it out for me and let me know if it chokes on anything, or if you see any ways it could be improved!

View 8 Replies View Related

Need Tech Review Of MSSQL Backup Chapter For O'Reilly Book

May 28, 2006

My name is W. Curtis Preston, and I'm the author of "Backup & Recovery"(formerly "Unix Backup & Recovery") from O'Reilly & Associates.(http://www.oreilly.com/catalog/unixbr/ )We're updating the book for 2006 and adding a chapter on SQL Serverbackup and recovery. Someone has already written what appears to be astrong chapter. The problem is that I'm not qualified to review it,since I'm not that familiar with SQL ServerCan anyone in this group step up to the plate and review the SQL Serverchapter? You would be mentioned in the acknowledgments of the book andreceive an autographed copy of the book.We're looking for two tech reviewers.

View 1 Replies View Related

SSRS(2005) Print Review && Page Number Reset ?s

Sep 17, 2007

Hi,

I'm having 2 issues on my first "real" SSRS report.
1. How to do a print preview via the preview tab. For print rendering, I have no print preview button on the preview toolbar. Is this normal? MS documention said that there is a Print Preview button. (BOL May 2007 - Designing & Creating reports -> working with report designer -> debugging and Publishing reports (Print Preview)) This report will always be rendered via the printer and it is a "pain" to have to always print it to see changes. The print layout option comes up all black with nothing viewable.

2. How do I reset page numbers back to 1 for report groups? I see no option for this. My report group requires a new page and I want page numbering to start at 1 when the grouping changes.

Note: I'm running VS2005 via Vista (with VS2005 Vista fix installed). SQL2005 SP2 also installed.

Any advice on this will be appreciated. I've spent too much time already where this should be obvious.

View 2 Replies View Related

SQL Server 2008 :: Review Data Type Mapping (Import And Export Wizard)

Jun 5, 2015

Not seeing the Review Data Type Mapping Screen in SQL Server Import and Export Wizard?

Is there only a certain version where that screen shows up?

I am trying to import data from an MS Access application to SQL Server and all of the connections are good, but some of the data isn't and if I let it migrate using this tool it crashes on the bad data and there is no data that migrates. The Review Data Type Mapping screen will allow me to bypass the records in error and load the rest. however, I can;t do that if I cannot see the screen.

View 9 Replies View Related

Right- I Need Training!!

May 12, 2006

Hi all,

my collegue is leaving, his masters in computer science has ensured he has solved most problems we've encountered iver two years...

now im told i need at least a few training sessions under my belt to take over parts of his job.

Basically i need sql server traing and vb but am confused as where to start, a lot of the courses ive looked at assume you have knowledge in certain areas, my problem is i have loads of gaps as ive learnt on the job so need some recommendations- are any of the MS courses geared to people like me or do you need a foundation in the subject....ive read stuff like SAMS teachyourself SQL and found it just doesn't go deep enough....too many examples are just skimmed over....it also doesn't teach you the kind of things i learn here....

im happy to go on a course which repeats stuff i already know whilst teaching me the fundamentals but can only seem to find course geared to specific job roles which require prior knowledge- so where did you guys start? im in the UK btw

greg

View 12 Replies View Related

SQL Training

Sep 15, 2006

I am new to the SQL enviroment and I am looking for a good course to learn more. I have been in the computer industry for a long time but not exposed to this program. I am looking for some training videos/online/books in order to learn more not just to pass a test for certification. I thought I would check some forums and see if anyone could offer up any suggestions of companies/authors for a person that has computer knowledge but knows nothing about SQL.

Thanks in advance for any suggestions.

View 4 Replies View Related

Training For SQLSERVER 7

Sep 10, 1999

Hi. I am just starting a new position as a dba for SQLSERVER. The first thing
I need to do is develop my training plan. I have begun reading SAMS Teach
yourself SQL Server 7.0 in 21 days. I would like to know what you (experienced)
dba's feel are the best training methods or resources. ie. CBT's, instructor led
classroom training, etc. Any feedback you can give me will be greatly appreciated.

thx,

deb

View 1 Replies View Related

Sql Admin Training

Feb 23, 2006

has anyone tried the cd/learning from sql usa
http://www.sqlusa.com/order2005/.
Interested in any input

View 1 Replies View Related

Training Scripts

Jun 10, 1999

Hi,

I am newbie on MS-SqlServer (6.5) I am looking for useful scripts for
learning Transact-SQL .
Is anyone known a good site for downloading some tools ?

Thanks,

Herve

View 1 Replies View Related

SQL Training Courses

Aug 8, 2006

I have the opportunity to take some MS SQL Server 2000 training courses for my Marketing Database Analayst job. The companies I have come accross so far are Learning Tree, ONLC Training Centers, and Hands On Technology Transfer, Inc. (HOTT). Has anyone had any experience with these companies?

The course I may be taking are
- Querying Microsoft® SQL Server™ 2000 with Transact-SQL
- Populating a Data Warehouse with Microsoft® SQL Server™ 2000 Data Transformation Services
- Administering a Microsoft® SQL Server™ 2000 Database

Any input is greatly appreciated,
Marc

View 1 Replies View Related

SQL Training In London

Mar 26, 2006

Hi there.

I am pretty new to SQL, I am really keen to trained and certified as a dba.
I have been working with access and vba for the last few years and I am really keen to get trained and qualified using SQL.

Can anyone suggest any good companies that can take me from little knowledge of SQL into a certified dba?

View 3 Replies View Related

Input On Training

May 8, 2007

Hi there,
I'll be going through a training couse for SQL Server next month. The class I'm signed up for is M2780: Maintaining a Microsoft® SQL Server™ 2005. My company uses SQL Server 2000 now and unless I give good reasons to upgrade to 2005, we won't be upgrading. I have very little DBA experience, but since I was told SQL Server is my responsibility, I figured it would make sense to go through some type of training for it. My questions are: Is there enough the same between the two that it makes sense for me to take this class? Are there good business reasons I can give for upgrading? If we don't upgrade is it worth taking a class for 2000 vs 2005?

Thanks for any input.

Marcie

View 2 Replies View Related

Sql Training Video And Others

Jan 11, 2008

Stumbled onto a good URL:
(I have checked out a few and they are pretty well done)

http://www.asp.net/learn/sql-videos/

JasonL @msft
http://blogs.msdn.com/usisvde/

View 5 Replies View Related

SQL Server Training

Feb 14, 2008

I think my employer will pay for some SQL training because I have a lot to learn and our needs are fairly involved.

It's my intention to learn and become MCTS in SQL Server 2005 and SQL Server 2005 Business Intelligence.

Where will we get the best bang for the buck for training in these areas?

View 5 Replies View Related

SSIS Training

May 1, 2006

Does any one knows the best training avaliable for SSIS where a person can learn from scratch how to use SSIS for data warehouse?

View 15 Replies View Related

SSIS Training?

May 8, 2007

Greetings all, I have a need to quickly spin up on SSIS. Can anyone suggest a class? I did a search on this forum but most of the the related threads were not all that recent.

Thanks in advance.

View 5 Replies View Related

SSIS Training

Mar 20, 2008

All,

Any recommendation for SSIS training? I am looking for class room training....my planning is to convert all DTS from 2000 to 2005. Thanks

View 5 Replies View Related

Looking For Training Recommendations In London

Jun 29, 2004

Hi,

I've been using Sybase for some years but by employer is moving (you guessed it) to MSSQL.

Can anyone recommend a TSQL and performance tuning training course for MSSQL in the London area?

Thanks,

Rob.

View 1 Replies View Related

What Is Best Training Software For Mcdba?

Sep 17, 2004

Hey guys,
Im wanted to know what was the best training software to pass the mcdba cert or better yet, what is best software for exam 70-228 which is the first exam to take. Classes are just too expensive right now for me=( I am open for suggestions. Thank Guys

View 1 Replies View Related

?Recommendations For Training/conferences?

Mar 22, 2006

I'm a solid SQL developer/dba and have some funds earmarked for training this year. I'd like to expand my dba skills...more specifically, I'd like to become a rock-solid enterprise level dba that has not only a solid foundation of skills but some innovative techniques for managing our corporate SQL servers.

I'm curious if anybody has recommendations on training or conferences that might help me dig into those skillsets for a couple of days.

Thanks for your insight.

alex8675

View 1 Replies View Related

SQL Server Training For MCTS

May 9, 2007

I am looking for some good training. I do not do well just reading books on my own. How have you trained for this cert.
I am a developer and would like to start moving in the DB Admin direction a little more. thanks

View 1 Replies View Related

Anybody Knows Who's Giving Training For MSOLAP

Feb 27, 2004

Hi
If anybody knows who is giving training for MSOLAP anywhere in india Pl geve me the address
My emailid sudhakarraaj@yahoo.co.in

View 14 Replies View Related

Log Shipping For Training Database

May 12, 2008

We have a user Training database that we would like to keep updated from our Production database. Users would make different modifications to the Training and Production databases. It is the user updates on the secondary that bother me and I have not seen anything that indicates Log Shipping would fail if new random records are added to both the secondary and primary.

Would Log Shipping be appropriate for this nightly update of Training from Production?

Thanks

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved