Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««1234»»»

Stairway to MDX - STEP 1: Getting Started with MDX Expand / Collapse
Author
Message
Posted Wednesday, March 2, 2011 11:22 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 5:32 PM
Points: 393, Visits: 1,593
I've relied on Mr. Pearson's Database Journal MDX and SSRS series for a while now, so I'm thrilled to see this series here - especially since it is targetted to 2008R2. About 90% of our reporting system uses SSRS to query cubes and I end up having to troubleshoot and clean up a lot of MDX that comes out of the GUI query designer in SSRS. I've love to see an article that takes on that topic.

Thanks,
MWise



Post #1072093
Posted Wednesday, March 2, 2011 1:29 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, November 9, 2012 2:48 PM
Points: 493, Visits: 636
Great article! I am looking forward to the future articles in the series. I wonder if power-pivot deals adequately with rendering axis beyond the second in excel. I worked with Proclarity back in 2005 and it had great rendering and building capability. I wrote a lot of MDX back then with functions, named sets, calculated members etc. However, being that I had to figure it out on my own I didn't do a great job of classifying it in my mind in a way that I could remember. I remember some of the functions being very counter intuitive and I am hopeful that this series will give me a better way to think about them.
Post #1072167
Posted Wednesday, March 2, 2011 1:50 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, August 7, 2014 8:32 PM
Points: 3,075, Visits: 782
Thanks for the series Bill.

Thanks,
Thomas LeBlanc
TheSmilingDBA


Thomas LeBlanc, MCITP DBA 2005, 2008 & MCDBA 2000
http://thesmilingdba.blogspot.com/
Post #1072185
Posted Thursday, March 3, 2011 9:28 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, December 16, 2013 10:42 AM
Points: 96, Visits: 434
Just about to cube a new warehouse, so this couldn't have come at a better time! Thanks!

-------------------------------------------------------------------------------------------------
My SQL Server Blog
Post #1072645
Posted Thursday, March 3, 2011 11:46 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, August 14, 2014 12:26 AM
Points: 5,334, Visits: 1,383
Nice intro.. good to read.


Post #1073087
Posted Wednesday, May 25, 2011 10:33 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 7:53 AM
Points: 3, Visits: 78
I'm having a problem with getting the cubes setup. I deployed the Adventure Works DW 2008 SE to my local machine and when I connect to the Analysis Server I can see the Adventure Works DW 2008R2 SE database. And I can drill down and see the Adventure Works cube, and drill further I see Measure Groups.

But when I highlighted the AW cube and clicked New Query I get a message: "Error loading metadata. No cubes were found". So I clicked the Process and get an error 'The datasource, "Adventure Works DW', contains an ImpersonationMode that is not supported for processing operations."

This is the same set of errors I was getting when I initially tried to deploy from BIDS. I found a post on here about this and changed the Deployment option to 'Do not process' and the Impersonation Information of the Data Source to 'Use the credentials of the current user'.

What security settings do I need to process these cubes?

*************************************************************************************

Well, one of the errors from some setting on the Inheritance tab referred to NT Network Authority. So, I gave that account db_owner on the AWDW2008R2 and I was able to process the project in BIDS. And I have items in the Measure Group of the query window.

Now the question is whether I have to always give NT AUTHORITY\NETWORK SERVICE db_owner rights to the databases I want to participate in AS?

Thanks.
Post #1114903
Posted Wednesday, May 25, 2011 2:37 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 5:32 PM
Points: 393, Visits: 1,593
You should be able to limit the access to read only of the tables you need to build your cube.


Post #1115056
Posted Wednesday, May 25, 2011 3:28 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 7:53 AM
Points: 3, Visits: 78
Mhlewis (5/25/2011)
You should be able to limit the access to read only of the tables you need to build your cube.


But it will be necessary to give the NT AUTHORITY\NETWORK SERVICE access to the underlying database? Can't some other account be used for this?
Post #1115089
Posted Tuesday, May 31, 2011 1:15 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, July 21, 2014 9:59 AM
Points: 886, Visits: 1,544
Newbie Question

I was referenced this series by a post on the forums but after reading the highlights (not the article in full) I'm not sure this is the right starting point.

I am familiar with BI in the buzz words and some terms but all of my DB experience has been on the relational model side and not in Data warehouses or Cubes and certainly not MDX. I inquired about the Date Warehouse/Model/Cube business because I thought it might provide a solution for reporting performance issues we have but now I'm not so sure. Part of my problem is that I believe many of the BI terms like Data MArt and Data Warehouse have been misused by others I have listened to and so I have the incorrect idea of what these are and how they work.

Is there any non-BI guru overview of ANALYSIS SEVICES and when/why/how to use it and how it relates to the traditional relation database model?


Thanks



Kindest Regards,

Just say No to Facebook!
Post #1117707
Posted Wednesday, November 2, 2011 7:47 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Sunday, August 17, 2014 7:56 AM
Points: 122, Visits: 94
SELECT
{[Date].[Calendar].[Calendar Quarter].&[2007]&[1],
[Date].[Calendar].[Calendar Quarter].&[2007]&[2] } ON AXIS (0),
[Reseller].[Reseller Type].[All Resellers] ON AXIS (1)
FROM [Adventure Works]
where [Measures].[Reseller Sales Amount]

and

SELECT
{[Date].[Calendar].[Calendar Quarter].&[2007]&[1],
[Date].[Calendar].[Calendar Quarter].&[2007]&[2] } ON AXIS (0),
[Reseller].[Reseller Type].[All Resellers] ON AXIS (1)
FROM [Adventure Works]

give me same result. Can somebody explain why ?
Post #1199287
« Prev Topic | Next Topic »

Add to briefcase ««1234»»»

Permissions Expand / Collapse