Search results for query: *

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

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

...question is, does 'INSERT...SELECT' allow you to simultaneously a) define a new field for your (existing) target table, while b) selecting all (*) from the source table, and c) filling the new field with data, based on one of the fields pulled in with b)? OR is the select filling data into...

...from has the SQL something like this (exact SQL unavailable, server is down), where 'saledate' is the newly formatted field: insert SALES select *, saledate = (case when sdate = 0 then 0 else cast (stuff(stuff(sdate + 1000000, 7) 3, 0, '/',) 6,0,'/') as smalldatetime ) from...

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

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

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.

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?

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

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

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

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

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

...They run as personal reports, but when you go to make 'administrator' as the user class to burst the report, userclass list comes back empty. #@%&* Cognos bugs!!! My boss turned 3 colors and went ballistic. It's be a real coup if there's a macro that can successfully burst to many (>150)...

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

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

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

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

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.

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