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 strongm 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. chertel

    division by zero - SQL 2000

    I am creating a cube in Microsoft SQL Server 2000. The Query of a calculated member returns text such as "1.#INF or 1.#J" instead of the number. Cause: The formula in the calculated member attempted to divide by zero. Solution: Change the formula to check for possible division by...
  2. chertel

    Caculated Members in SQL

    I am having an issue veiwing large amounts of data when the data is a caculated measure. If it is a simple measure coming from the fact table and I veiw the same data it works. Ex. Customer by Item Sales. I am using Microsoft SQL Server 2000 to build cubes/measures and then I am viewing the...
  3. chertel

    Have Suggestions for a Front End Tool?

    I am currently using Microsoft Excel pivot tables to access data cubes from SQL Server 2002 as a front end tool for users to access sales data. I have run into issues when I am asking the pivot to filter too much. Does anyone have any suggestions on another frontend tool for cubes that does not...
  4. chertel

    Excel 2002 OLAP and SQL 2000

    I am useing MS Analysis Server 2000 for building the Cubes & to display the result I am using MS-Excel 2002. In the cube which I have made, I have given the enabled the Drill Through option and selected all fields to drill through in the cube. I am able to see the row level data in the data...
  5. chertel

    Drill Down in Excel 2002 OLAP and SQL 2000

    I am useing MS Analysis Server 2000 for building the Cubes & to display the result I am using MS-Excel 2002. In the cube which I have made, I have given the enabled the Drill Through option and selected all fields to drill through in the cube. I am able to see the row level data in the data...
  6. chertel

    SQL Insert Queries

    I am trying to take an excel table with all the info that needs to be added to my ERP system Table. All of these values need to be inserted into this table. I took the info from excel exported it, messaged the data so it was formatted correctly and then pasted it into this insert statement. I...
  7. chertel

    SQL Insert Queries

    Hi- I am writing an insert query through Microsoft Access and I am having trouble on how to get more than one row updated at a time. Here is the statement that I have working now. INSERT INTO F4104...
  8. chertel

    SQL Insert Queries

    Hi- I am writing an insert query through Microsoft Access and I am having trouble on how to get more than one row updated at a time. Here is the statement that I have working now. INSERT INTO F4104...
  9. chertel

    Subquery in INSERT Statement

    I am trying to add records to a table which is located in my ERP Software (which is JD Edwards). I have a simple INSERT statement (in Microsoft Access) that works if I manually include the data that I want inserted it works fine...BUT...I have a table that I imported from excel and it want to...
  10. chertel

    Subquery in INSERT Statement

    I am trying to add records to a table which is located in my ERP Software. I have a simple INSERT statement that works if I manually include the data that I want inserted it works fine...BUT...I have a table that I imported from excel and it want to use this as reference for the data insert. I...

Part and Inventory Search

Back
Top