## New to Analysis Service

MS SQL SERVER

### Next

• 1. MDX Query Optimisation
Hi I have a query that is based on a time dimension as follows. [Day of week] - [Hour] - [Minute] as the design of the levels. I have to run a query based on different sets from this dimension (eg: Mon 8:30 to 12:00 + Tues 9:00 to 13:00 + Thurs to Sat 8:45 to 13:15) which will be run for a certain date range. Firstly, For ease of MDX we created the dimension as one dimension rather than day and time. (With keys we can pinpoint a minute on a day rather than having to do crossjoin sets). WOuld you agree with this architecture. Secondly, when it comes to actually querying the data, does the standard MDX keywords have any advantage over specifying a time range: eg. Would there be any difference in the following two queries and which would be quicker (if anyone has had a similar problem before) Sum([Time].[Minute].[8:30]:[Time].[Minute].[8:59]) or Sum([Time].[Minute].[8:30]:[Time].[Minute].[8:30].Parent.Lastchild) Thanks
• 2. Can I make a union of queries?
I was wondering if there was a way to make a union of queries? select {[RunningTotalSubs], [test1]} on Columns, CrossJoin([Age Group].[All Age Group].children, TopCount( { [DMA].children}, 5, ([RunningTotalSubs]))) on Rows from [consumer_analysis] where [Zone Id].&[14] result: AGE RunningTotalSubs 20-30 1000 30-40 2000 40-50 1000 select {[RunningTotalSubs], [test1]} on Columns, CrossJoin([Gender].[All Gender].children, TopCount( { [DMA].children}, 5, ([RunningTotalSubs]))) on Rows from [consumer_analysis] where [Zone Id].&[14] result: GENDER RunningTotalSubs M 1000 F 2000 U 1000 Is there a way to combine the queries so I can get a result set like: AGE-GENDER Total 20-30 1000 30-40 2000 40-50 1000 M 1000 F 2000 U 1000
We have two SQL Server 2000 Analysis Servers - both are set up identically. Both have had their repositories migrated to SQL Server. I can register one of the servers - but not the other one. When I try to register the second server I get a "Path Not Found" error. This seems to be tied to my login - as I get this from a number of machines. Anyone have any ideas what might be causing this? I've been through the registry and all the settings and I can't see anything. Thanks In Advance, Matt

### New to Analysis Service

Hi all,

I am new to Analysis Services.  Where should I start: resources, web sites,
books...

Thanks.

Han.

### Re: New to Analysis Service

Han,

Try this website:
http://www.**--****.com/

If you like webcasts (video learning) or virtual labs, check this:
http://www.**--****.com/

For list of books check this:
http://www.**--****.com/

Regards,

Vidas M.
http://www.**--****.com/

### Re: New to Analysis Service

Lynn Langits book is the best for newbies.  I recommend it all the time.

APRESS -- Foundations of Business Intelligence.  It has meat, but explains
the basics.

Paperback: 396 pages
Publisher: Apress (April 24, 2007)
Language: English
ISBN-10: 1590598342
ISBN-13: 978-1590598344
http://www.**--****.com/

--
Sandra Mueller, MCT
http://www.**--****.com/

I would like to view the AS 2005 interface that business users (not
developers) will see from the new Analysis Services for SQL 2005. I have
searched for examples online and have been unsuccessful.

Can someone provide information about the Business users interface for AS
2005?

TIA

Does anybody know of a good introduction to SQL Analysis services
(2005) for somebody who is a database developer/DBA to get started in
creating analysis cubes?

As for example I have noticed there are different terms used to
reference the fields in a database and told that the data needs to be
denormalised.

I am very new to analysis services .I found the CREATE CUBE query in
Books online .But i don't where to execute this query
plz reply for me
Thanks to all

Hey I just found out about this cool Data Cube stuff in Analysis
services.  I have no idea how to use Analysis services or make a data
cube but it would definitely help me out a lot at work. Does anyone
have a simple, easy to follow tutorial?  It would be preferable if it
was a video one or has screen shots.  Thanks!