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 Rhinorhino 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: sweetleaf
  • Content: Threads
  • Order by date
  1. sweetleaf

    MS Access - exporting to excel

    Hi, Does anyone know how to extract table data to excel when there are more than 65k rows (I think 65k is the limit to how many rows you can add in an excel worksheet)? I know that one alternative is to drag and highlight which rows but I have nearly 300k rows and doing it this way would take...
  2. sweetleaf

    Standard for change mgt of data feeds

    Hi, Does anyone know of an existing Data Feed Change Management Standard that can be leveraged? I could create one for my org but would rather leverage something that already does the job. Any links, comments or ideas are much appreciated!
  3. sweetleaf

    Change Mgt Standard for Data Feeds

    Hi, Does anyone know of an existing Data Feed Change Management Standard that can be leveraged? I could create one for my org but would rather leverage something that already does the job. Any links, comments or ideas are much appreciated!
  4. sweetleaf

    Customer/product master data

    Hello, I was wondering of what others have done to address master data scenarios such as this one: there are a handful of systems all containing customer and product information which is buried into the transaction data. there are a few systems to track sales and products, and others for...
  5. sweetleaf

    Cognos usage tracking

    Hello, Is there a way within Cognos to report on who in your company is using Cognos and how (eg. developing reports, running reports, viewing reports ect)... Thanks
  6. sweetleaf

    Concurrent execution of workflows

    Hello, Does anyone know whether it is possible to run the same job flow concurrently? The scenario is that staggered data gets entered into the source tables in question, but clients still need the target outputs with whatever data is available regardless. I am not sure if there is a way to do...
  7. sweetleaf

    Question about roles & responsibilities

    Its funny how some view BI as encompassing DW (and data integration and processes such as MDM, ODS etc), and others classify BI as merely the presentation layer of an overall reporting solution. Is there general and accepted consensus and direction on this topic that right now seems to still be...
  8. sweetleaf

    Powercenter and IMS

    Hi - does anyone here know whether PWCTR can directly extract from non relational databases such as IMS - if so, then how? thanks for any insights!
  9. sweetleaf

    ETL and MQ/messaging

    Hi - I was wondering if anyone knew a use for when it would be useful to combine etl with a messaging tool such as IBM MQ? Has anyone done this? - Thanks
  10. sweetleaf

    Materialized views - questions

    How are mat views different than logical views. My challenge is i don't want to grant power users direct access to tables for their end-user reporting needs. But IT needs to give them some way to analyze their data in an ad hoc way... -Has anyone gone through something similar? -Are Oracle...
  11. sweetleaf

    SQL Server materialized views - question

    Does SQL Server have an equivalent to Oracle materialized views? How are mat views different than logical views. My chellenge is i don't want to grant power users direct access to tables for their reporting needs. But IT needs to give them some way to analyze their data in an ad hoc way... Any...
  12. sweetleaf

    New to BOXI - pls help

    I am very new to BOBJ and have a couple questions about universes. My task is that I've got about 20 tables (2 facts), and will need to develop a universe or two. Reports will then sit on top of the universe(s) and be used by a dozen users. I'm basically setting up a new pilot environment for...
  13. sweetleaf

    mainframe DW conversion to SQL svr

    Hi, My company has a data warehouse thats about .5 terabytes in size with over 300 tables. Its currently in db2 on the mainframe. We're thinking of converting it to MS SQL Server. But I'm not really sold on what benefits this brings. Does anyone have have ideas or specific examples in support...
  14. sweetleaf

    Analysis Services and XP

    Does anyone here know whether analysis services (SQL 2000) can run under XP? Thanks.
  15. sweetleaf

    Powercenter and Acord based XML

    Has anyone used Powercenter to process Acord - based xml? Reason I'm asking is because I am running into a problem doing this since one of the Acord xml schemas is over 50 megs. Parsing and validating it against the xml file is not working. I'm thinking I can't be the only one using an etl...
  16. sweetleaf

    DTS cannot connect to Analysis Services in a timely manner

    Does anyone know what typically is the cause for this error? I have scheduled DTS pkgs that take 3-5 hours to establish a connection but once they do, OLAP cube creation processes are fine... Thanks for any help!
  17. sweetleaf

    Cable modem shows connected but can't use internet

    All lights on my cable modem indicate that I am connected to the internet but I cannot launch my browser, or Outlook Express, successfully. I think I have picked up a computer virus but cannot even download the latest virus signatures since I cannot connect. Has anyone else here experienced...
  18. sweetleaf

    Process extension error

    Getting this error intermittently when running a Crystal report... anyone know what this is and how to address it?
  19. sweetleaf

    DW's better on distributed or mainframe?

    What if any are the biggest reasons for why to consolidate all a company's DW's onto distributed vs mainframe db's? or even more granularly onto one dbms platform such as oracle/sql etc? Does anyone know if there is an advantage that distributed has over mainframe when it comes to data...
  20. sweetleaf

    DW for multiple countries

    If a company has offices spread across Asia, and it wants to embark on a DW project, (considering the language/legal/currency/cultural differences etc) would you suggest having a single integrated DW or a DW for each country?

Part and Inventory Search

Back
Top