Search results for query: *

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...

Thanks, Zathras, I thought all systems would ignore indexes when functions were applied to them in Where clauses. (Yes, I learned under Oracle, long ago) Travis can use the CAST statement to do this. Though I'm sure Terry's article will offer better suggestions. I plan on checking it out...

I don't think that SwampBoogie's answer will work... isn't count(*) static throughout the query result set? This might work in an update trigger, so long as you used transaction controls properly. Too bad the sequences mechanisim for Identity fields isn't exposed. (For example, Oracle has...

You can use SQL Agent and create a Job. You can direct the output of each Job Step. This is done through Enterprise Manager. If you want, you can manipulate the Job Step's OutputFileName programatically using C (or, perhaps VB.net).

1) The BETWEEN solution preserves the index. 2) If this is a ubiquitous problem, you might want to understand the following: select getdate(), cast(getdate() as float), cast(getdate() as integer) You can use this technique to eliminate the decimal part of the date.

I have several SQL reports I want to run from a single script file. I'd like the output from different reports to go to different files. I can't find a script command to do this. If you don't know the answer, can you tell me where to look?