Recent content by ajc123

From http://www.microsoft.com/msj/0899/mdx/mdx.aspx : In constructing MDX statements, it is often necessary to relate a current member value to others in the cube hierarchy. MDX has many methods that can be applied to a member to traverse this hierarchy. The most commonly used ones are...

Newbie question: The "Category" Hierarchy has two levels. I want to show both the Category and Sub-Category as my rows. It's easy to check these levels in a Pivot Table, but how do I get both to show up using MDX? I'm using the syntax: {[Category].[MainCategory].members...

Thanks again Corilynn. I eventually resorted to Microsoft SOP, and checked my version levels on everything. It turns out that I hadn't installed SP2 for Analysis Services on the client machines. They worked, but not properly! The Analytics Services upgrade is seperate from the Server 2000...

Thanks Corilynn. I discovered this. The trick is that the cubes need to use Shared Dimensions. Once I got that, it was smooth sailing!

Additional note -- I can connect to those two cubes from the client when I use Analysis Manager. I've got the right version of MDAC -- 2.7.

Is there a work-arund for the limitation that only one measure in a cube can be a Count Distinct? I've got two! Thanks for sharing!

I created a cube on my server, then connected to that cube using MS Excel from a client system. I didn't like some of the dimensions, so I deleted and re-created the first cube, and created a second cube. Now I can't connect to any of the cubes from Excel. I get the message "Excel cannot...

I want to retrieve the maximum entitlement for an employee, which is inherited from his ancestor records. I need to select the max(value) from the set of all ancestors. Looks like I need to use a Stored Procedure to do this. I have 100,000 records, so I was hoping to do it with a query.

The issue here is that I have a mutiple-level hierarchy, and want to see all the relations. I want to know that "Steve Jobs" ultimately is in the "Bill Gates" Hierarchy.

For the past decade or so (at least :-), I've heard it referred to as 1. See-Qwell (or Sequel) by sales guys, coders, gurus and other speakers, including software executives at conferences around the country. "S.Q.L." is used rarely, in my experience. I hope this response isn't too...

SQL Server has "TOP n" clause as a feature of the SELECT statement and Oracle has the "ROWNUM" pseudocolumn, which provide shortcuts to a solution to the challenge. Those shortcuts will provide you with working code (and this is a MS SQL Server forum). However, academic...

Have you tried the TOP function? As in: SELECT TOP 1 refid, col1, col2 FROM FOO ORDER BY REFID It's a benefit of SQL Server.0

Oracle 8i will work as well and is a free download. MySQL is also free and available for linux, and I'm not sure about a windows viersion.

Somebody sent me lots of data in a self-referencing hierarchy. There's an "ID" field and a "Parent_ID" field. In another popular database, I would use a "Connect_By" clause. Is there a way to do this in SQL Server? Or has someone got some spiffy TSQL code to recurse...

Thanks, Terry. I was wondering if Query Manager supported the old command line instructions, but didn't know what the BCP commands were. Turns out QM does not support the BCP commands. A temporary solution has been to build a Job Stream, but it's slow going because I have to go through the GUI...