Recent content by benbotektips

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

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

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

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

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

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