New to Analysis Service

MS SQL SERVER

    Sponsored Links

    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
  • 3. Path Not Found erro
    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

Postby SGFu » Fri, 17 Oct 2008 01:00:01 GMT

Hi all,

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

Thanks.

Han.

Re: New to Analysis Service

Postby Vidas M. » Sat, 18 Oct 2008 07:46:44 GMT

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

Postby Sandra Mueller » Sat, 18 Oct 2008 21:51:36 GMT

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/ 








Similar Threads:

1.User Interface for NEW AS (Analysis Services) 2005 Business Users

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

2.New to Analysis Services

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.

3.Hai New to analysis services

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

4.New to Analysis Services - Cube tutorial please!!!

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!

5.Processing 64-bit cube on 64-bit Analysis Services happening on 32-bit Analysis Services

6. Adding new member to an existing role in Analysis Services 2005

7. Analysis Services New Calculated Member

8. New Excel-Addin for Analysis Services Speed Problem



Return to MS SQL SERVER

 

Who is online

Users browsing this forum: No registered users and 27 guest