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!

  • Congratulations Chriss Miller 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: *

  • Users: pabloj
  • Content: Threads
  • Order by date
  1. pabloj

    OpenLDAP as a linked server

    Hi, did anyone got OpenLDAP (set up as a linked server) to return more than ADsPath? I'm able to put appropriate clauses in where part of the query but not to choose what is returned. Stick to your guns
  2. pabloj

    Something like Oracle's ntile function?

    Hi all, I have to compute ntile in sqlserver, my desired result should be something like: CUST_NO SALES_1999 DECILE_1999 SALES_2000 DECILE_2000 ---------- ---------- ----------- ---------- ----------- 1 6 1 12 1 2 20 1...
  3. pabloj

    Average number of days between purchases

    Hi, I have a cube similar to Foodmart with 3 dimensions (Time, Invoice, Customer, Product) and I need to calculate the average number of days between two invoices for the same customer. Could anyone suggest an MDX solution (calculated measure?) or shall I compute that outside of the cube and...
  4. pabloj

    Excel, add comment to cell

    Hi, could you please tell me how to programmatically add a comment to a cell selected by the user? Stick to your guns
  5. pabloj

    Partial refresh of partitioned materialized view?

    Hi all, I'm evaluating materialized views to build summary tables and I've run in a pretty hard problem. My materialized view is based on a complex view, so I can't refresh FAST ON COMMIT, the source view will contain a LOT of rows so some delta update is mandatory. I'm evaluating the use of a...
  6. pabloj

    ordering rows

    Hi, I have a financial report (excel) in which I need to custom order rows, not alphabetical or key :-(, I've thought of putting an "order" column (number) in the table and use it, maybe building the item name with the "order". Does anyone have a better idea? Thanks in advance for your help...
  7. pabloj

    Pocket excel and Analysis services

    Hi, does anyone know if it is possible to browse cubes from PocketExcel? Or is it better to use a web interface and in this case, "thin web client" (html and javascript only) or "office web components"? Thanks in advance for any help!! Stick to your guns
  8. pabloj

    Retrieve MDX query from Excel

    Hi, is there any way to retrieve the MDX statement generated by Excel while you are browsing a cube? Thanks in advance for any help! Stick to your guns

Part and Inventory Search

Back
Top