Data warehousing/Business intelligence Questions

1

Attend TDWI in San Diego 8/7-8/12 (Sponsored)
Attend the TDWI San Diego Conference, August 7-12, where you will gain BI/DW knowledge you can apply immediately, interact with experienced instructors, and network with hundreds of peers. Learn more

Answer Question   |  June 29, 2011  2:27 PM
Business Intelligence, Data warehousing, Data warehousing/Business intelligence
asked by:
16,755 pts.

function to subtract 200 days from date
I need to write the filter condition in cognos as follows: YRMOSDOS between (&YRMOSDOS – 200) AND (&YRMOSDOS) where YRMOSDOS is in date form. How do I achieve it? The database is in db2. Decimal function does not work. Please help. Thanks a lot.

Answer Question   |  June 29, 2005  11:20 AM
Data warehousing/Business intelligence, Database Management Systems, DB2, Development, MySQL, Software testing
asked by:
0 pts.

Monitor Internet Bandwidth
Good day, we are using windows2000 smallbusiness server in our organisation with Exchange,Dns and Isa server configured. 1. I want to monitor the internet usage by the users. 2. I want to take a report on monthly or daily basis how much mb/gb utilised By Each User. Thanks for u’r reply in advance.

Answer Question   |  December 29, 2004  1:55 AM
Active Directory, Administration, Application management, Auditing, Availability, Backup, Backup & recovery, Bandwidth, Benchmarking, Bind, BroadVision, Business Objects, Call Centers, Clarify Inc., CLB, Client management, Clustering/High availability, Component Load Balancing, Content filtering, Corporate portal applications, Customer relationship management applications, Data analysis, Data center operations, Data mining/analysis, Data warehousing/Business intelligence, Database Management Systems, DataCenter, Datacenter Server, DB2 administration, Desktop security, Desktops, DHCP, Distributed File System, DNS, E-business, E-mail applications, ERP, Exchange, Exchange 2000, Exchange 2003, Exchange 5.5, Exchange Server ActiveSync, FAT and NTFS, Fault isolation, Firewalls, General Directories, Graphical User Interfaces, Handheld, Hardware, Help Desk, Information risk management, Integration/Connectivity, Intel servers, IT architecture, Knowledge management applications, Licensing, Lotus Domino, Mail protocols, Maintenance, Major Vendors, Microsoft Internet Information Server, Microsoft Windows, Monitoring, Netscape Mail, Network applications management, Network management software, Network monitoring, Network requirements, Network testing, Networking, Networking Equipment, Networking services, Office Applications, Operating system platforms, Operating systems, Outlook, PC/Windows Connectivity, Performance management, Performance/Tuning, Planning, Policies, POP3, Protocol analysis, Remote management, Reporting, ROI & cost justification, Routers, S/MIME, Security, Security management, Security products, Sendmail, Server consolidation, Server management, Server-based/Thin-client computing, Servers, Services, Software, Software distribution, Software Quality Assurance, Spam, Storage, System monitoring, System utilities, Tech support, Technical support, Third-party services, Vendor support, Virus protection, Web services, Windows, Windows 2000 desktop, Windows 2000 Server, Windows client administration and maintenance, Windows on Intel, Windows Server 2003
asked by:
0 pts.

DB2/400 SQL Sub Query Performance?
Here is the problem. Table INVEHH is a (Events header table) with about 500 records and INVEHD (Event Details) with about 22 million records. These tables are on a DB2/400 database. 1) Original Query that takes forever: select EVENT, INUMBR, ISTORE, EVHYY, EVHMM, EVHDD from INVEHD where EVENT in (Select EVENT from INVEHH where (EVHYY*10000 [...]

Answer Question   |  October 20, 2009  8:40 AM
Data warehousing/Business intelligence, Database Management Systems, DB2, DB2 Universal Database, UDB for iSeries/i5
asked by:
0 pts.

asked by:
0 pts.

1