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

    Using a period in table name

    This one statement, "I copied the table name and pasted it in the analyzer, added "select * from" in the front, and put the table name in brackets []. When I ran the query it worked." saved me from an hour of aggravation. I couldn't figure how to get the table merged with another that didn't...
  2. benbotektips

    Sql-server 2003, Confusion On The 'insert...select' Functionality

    We're getting warmer. I agree with SQLsister about the bad idea of 'select *', however, I need a quick and dirty way to add on one field to a long production table, that already exists. Since I own the step that will update, I can recreate it as I want. What Amrita's saying, is I can create a...
  3. benbotektips

    Sql-server 2003, Confusion On The 'insert...select' Functionality

    Thanx. This is very informative for scripting, and I have saved it for future need. It's ambitious for what I want to do now. I can always just do the 'ALTER TABLE' once, in Query Analyzer, for each table I want to have the reformatted new date fields in. The basic question is, does...
  4. benbotektips

    Sql-server 2003, Confusion On The 'insert...select' Functionality

    I have some files on the AS400 to be copied into SQL-Server, for further massage/ETL. I'm copying an existing DTS package, and everything works except adding fields onto an existing table. I think I'm misunderstanding the 'INSERT...SELECT' functionality. In the AS400 files, there's a date field...
  5. benbotektips

    row limit/ execution limit blowup

    There are 2 tables, a MEMBER with 1.1 million rows, ACTIVITY with 50 million (Yes, I know it's too big; try arguing with corporate execs who overpromise on projects)! The report template needs to pull in an attribute of member.company id (common to both tables), and give the average number of...
  6. benbotektips

    subtracting dates

    I got a fact created, made a metric to get avg(the fact), and it worx great. Well done!
  7. benbotektips

    binary

    An alternative is available, in Oracle and binary anyway. There's a function 'bitand (number1, number2)', which ANDs the (base2) bits. So, bitand (status, 1) will be true u if the 1st bit is on, bitand (status, 128), will be true u if the 7th bit is on, etc.
  8. benbotektips

    subtracting dates

    I don't have permission to create a fact, I may get to create an attribute. Can I accomplish the same thing by creating an attrbute with the ApplySimple fiormula?
  9. benbotektips

    subtracting dates

    I have to find a number of days between a registration & activity, 2 date fields. These date fields are attributes. I'm trying to get the average number of days, for many rows within 1 group. So, the heirarchy is company avg. days between reg. & activity. The 'Apply Simple' formula I keep...
  10. benbotektips

    binary

    Thanx, Santa. This is a simple, practical solution.
  11. benbotektips

    binary

    Any way to convert a number field to its binary equivalent (ex. BINARY(15) = 1111, BINARY(13) = 1101 )?
  12. benbotektips

    Hi Friends Anybody ... If u have

    You most definitely can create >1 cubes from a model. Simply create the 'master' model, with every dimension & measure you'd need, then create separate cubes (by going to the 'Powercubes' window and 'insert new cube'), then customize, by including or omitting dimensions, or creating a view...
  13. benbotektips

    Can't burst in IWR 7.1

    We upgraded from 7.0 to 7.1, uninstalled 7.0 first, then installed and configured 7.1. I created newsboxes and the newsitems (reports), and they run fine, with filtering, as stand-alone, personal reports. However, there are some that need to be bursted. So, I set security, give read access to...
  14. benbotektips

    Hi, I need to creat a CognoScrip

    If it's not much trouble, could I impose on you to post this macro, if done? We just upgraded to 7.1, and I can't get the bursting to work via Upfront (anyone else have this problem)? They run as personal reports, but when you go to make 'administrator' as the user class to burst the report...
  15. benbotektips

    .PY? versus .MDL files

    I create and edit the .mdl's (Cognos claims they're incorruptible, and so far none have, while plenty of .pyi's have been), then save as .pyi's, and put the database logon info into the pyi's, then save again, for the macros to run. I never do any real work (editing) on the pyi's, they...
  16. benbotektips

    Impromptu Admin 7.1 on W2K - can't create queries

    As a corrolary, I got zapped by the printer problem, on another issue. My .imr reports would slow down to a crawl, a query that used to take a minute would take an hour. After several unsuccessful fixes, I noticed the printer driver was slightly a different version than the printer I had set up...
  17. benbotektips

    Tips to improve Impromptu report performance?

    I found that the best thing to do with Impromptu, is let it do as little thinking (read:calculations) as possible, and work it like a data echoer - good for formatting and presentation, not deep thinking. In other words, take care of the data at the database level. This could mean creating a...
  18. benbotektips

    Impromptu and OLAP

    Yup. In your Transformer map, double-click on the field that's currently building the dimension, and there'll be a window with some tabs, should be on the 1st tab, 'Source'. Then, look under 'associations'. You'll have only the 'source', with your dimension 20-byte description. Open this folder...
  19. benbotektips

    Converting Impromptu 6.0 to 7.0

    A shot in the dark - try qualifiying the database fields more or less. Open the catalog, go to 'tables' on the menu, hit the 'qualification' tab, then experiment with making the database/table fields more or less qualified. Sometimes this worx.
  20. benbotektips

    Divide By Zero in Impromptu

    Well, not to quibble, but our reports here are pretty vanilla, no list headers or footers, and we're running 6.0, rolling out 7.1. So, I guess we just got lucky, having unfancy list reports, with heavy SQL and grouping, but no headers & footers. For any new division fields, I'll try Griff's...

Part and Inventory Search

Back
Top