• Oracle OLAP degenerate dimension

    HI, HI, Say, I want to create a data mart for sales Dimension: region,products Degenerate dimension: Order Number Measures: price,quantity Qyery: cross product A region B show order numbers where total quantity sold is more than 100000 How to achive this Oracle(11g) AWM or any other tool? How can I...

    VinayOLAP30 pointsBadges:
  • Script to extract files information from ftp server

    Hi Wonder if you could help me with the following please. I would like to construct a script (in any language whichever it's easiest) which when run, it will log on to a ftp server using a generic account and password, then list the files in a specific folder that begins with the string "abc". The...

    Aiko2720 pointsBadges:
  • Application.FileSearch no longer exists (in 2007)

    My company is migrating to Office 2007 - I have VBA code that works wonderfully in "older" versions of Access, but will not work in 2007. One in particular is "Application.FileSearch" - what can I use instead? (And why was it removed??)

    Dhoosier5 pointsBadges:
  • SQL Server 2005 log shipping network pass thru security

    I have a need to ship logs to a remote secondary server that is in a different domain and without domain trusts. I have configured the SQL Agent on each machine to use a local account (.\SQLAgent) with the passwords the same on both machine. The secondary machine can read the network share that...

    Jando9995 pointsBadges:
  • Need Help With Multiple Conditions and Constraints for Access 2007 VBA Event

    Hi, I’m working with VBA for On Click Event procedures in Access 2007. My knowledge of Visual Basic is rudimentary and I've come against a business rule I can't even begin to figure out how to code. I work at a college and was asked to build a database for a student conference we're hosting. One...

    Dataempress115 pointsBadges:
  • SQL relational database

    A relational database contains the following tables: Employee (EmployeeNo, EmployeeName, DateOfBirth, JobDescription,DeptNo) Project (ProjectNo, ProjectName, Location)Assignment (EmployeeNo, ProjectNo, Role-in-Project)Formulate the following using SQL:i. Find the names of all employees assigned to...

    Lystra10 pointsBadges:
  • Pop-up reminders in Microsoft Access

    How to create popup reminder in Microsoft Access?i do not know to create with macro.can give me the answer step by step?

    Wanie5 pointsBadges:
  • Format a field

    I need to format a text box to begin with a zero with no decimals (i.e. 0310) If I type in 0310, it appears as 310.

    Sue775 pointsBadges:
  • Crystal Reports last twelve months

    I wrote a report that accululates invoice totals for each customer in a sql database based on period and year for period. I manually entered the last 11 months in the formulas by taking current month minus 1, then current month plus 10, year minus one and so forth. How can I make this process...

    Dunbar5 pointsBadges:
  • Connection failure using dotnet 1.0 and Oracle client 10g with Oracle 10g server

    Hi, I have application developed on dotnet 1.0 ( VS 2003) and Oracle 10g server. Client machine has windows XP ( sp2), Oracle client 10g, Oracle.net, mdac 2.6. ODBC connection is sucessful and using toad also i can connect client machine to server but using ditnet application (...

    Mkb20 pointsBadges:
  • Windows Sharepoint Servs 3.0 – Linking existing Access 2007 Database with new list.

    Is there any way I can link a pre-existing table/query in an Access 2007 database with a new Sharepoint list? At the moment, the only way I can find to do this is to copy the information from Access to Sharepoint, then import the copied data back to Access and link these two. I need to be able to...

    Domc1115 pointsBadges:
  • Subject: Limiting information in combobox

    I have two comboboxes, one shows a list of customers, the other shows a list of contracts. One customer can have mutliple contracts, but a contract can only have one customer. I want to limit the contracts in the second combobox to only the contracts of the customer in the first combobox. I have...

    Gavaughn10 pointsBadges:
  • convert csv file to pf file

    i have a file on IFS in .csv format.how to copy this file to pf format in another library.

    Kapiltiwari350 pointsBadges:
  • ActiveX control for Webcam

    I'm creating an application with a webcam to get a snapshot data image, i want to use MS Access for database and use Crystal Report 10 for the print out. My friend told me if i want to use the cam then i hav to use the activeX control, can u help me, please..

    Abekane5 pointsBadges:
  • AS/400 command to convert a file to .csv

    Hi, If I remember correctly thare is an iseries command to convert a file to .csv with the OS environment. Can anyone remember it. Not using Client Access. Thanks.

    tjgm88995 pointsBadges:
  • Process of swapping the kernels

    HI i am working on a sap application where the OS is OS400 and the Data Base is DB2/400, now i want to know the process of swapping the kernels Can any one explain it or refer some meteral for teh same . thanks in advance kiran

    Chebrolu20 pointsBadges:
  • DDL in PL/SQL procedure

    I have a question, i create drop and create a table in pl/sql proc using execute immediate. Later I declare a ref cursor, to process data from table created. Problem is the procedure executes correctly, but after execution procedure becomes invalid. How can i solve this issue. Thanks in advance.

    Binwal5 pointsBadges:
  • Custom alert messages with SQL

    sql custom messages, how to put a message box if value entered is already taken? and if value entered does not exist?

    Yosbeeebajay10 pointsBadges:
  • Open XL file from ILE program

    We have a process that converts a spooled file into a .CSV file and stores it in a folder on the IFS. The user then opens Excel and locates and opens the file for editing etc. Is there a way to open up the file in Excel for them after its transferred to the IFS? Could you show me code examples...

    filuphaze475 pointsBadges:
  • Database report output shows multiple pages

    When I run a report, I see multiple pages, but running the query directly on the database using TOAD gives me only one record. How do I find why the query gives multiple pages? I can ofcourse set printing option as "First Page" for all the fields, but I need to know why the duplication occurs.

    Ms123115 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following