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 TouchToneTommy 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: chertel
  • Content: Threads
  • Order by date
  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

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

    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...
  9. 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