Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ajc123

    MDX-Percent of parent

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

    MDX: Showing two levels in a dimension

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

    Excel OLAP "Excel cannot find OLAP cube Test02...."

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

    Only One Distinct Count Measure?

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

    Excel OLAP "Excel cannot find OLAP cube Test02...."

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

    Only One Distinct Count Measure?

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

    Excel OLAP "Excel cannot find OLAP cube Test02...."

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

    Self-referencing Hierarchy?

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

    Self-referencing Hierarchy?

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

    Pronunciation

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

    Retrive UNIQUE Records

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

    Retrive UNIQUE Records

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

    Need list od desktop SQL DBMS's

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

    Self-referencing Hierarchy?

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

    Query Manager -- Start a New Output File

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

    time issue in datetime field

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

    Does this need a cursor?

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

    Urgent : Can I create/Open text file from Stored Procedure ?

    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).
  19. ajc123

    time issue in datetime field

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

    Query Manager -- Start a New Output File

    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?

Part and Inventory Search

Back
Top