Recent content by toddl

When I've had that requirement, we just mask the column by looking at what group the member is in. For example, the column would be displayed for all users, but for users without the security clearance the columb just said **Secured Information. This was simple, and handled in the model so the...

I commented on your other post, so I'll give my little tidbit here as well. I'll stick with commenting on the bad points. I find tracking the data to be interesting, especially if you're not involved in the ETL portion, by tracking it through the areas you're able to understand it better. A...

Likely depends on what you want to do. I'd go with option 2, but wouldn't consider it dull at all. I'm currently in the BI field. If you truly get into BI, it can be really rewarding in terms of learning about the company, understanding business processes and meeting with executives. Theres...

What version of Cognos are you using? The sql and joins are generally handled in the Model/Catalog although you can do direct SQL if you really want.

If you can't find a way to do it in capabilities section in cognos admin, you could modify the system.xml to hide the option for a group of users.

Good luck! I've setup and managed a cognos environment in an outpatient clinic setting for many years. You're going to find it hard to find people using the exact same software that use Cognos (and use the program and cognos in the same way as your own). Ever more you'll find companies that...

Your report has Emp Manager, so it already has recipient names it should email too. If you're emailing people, you should have a table that has the CAMID (or email address) of all your users. You would just link this table to Emp Manager.

Tools --> Show Generated SQL

Hi Blom, They've rejected my .dmp files, saying they were too big and unable to isolate a problem. They're still working on a fix to the AAA error. I'm on 8.3.81.20 and have applied a ton of hot site fixes. We've basically decided that the AAA error isn't really a problem since we can...

Some of my users get the 'CAM_AAA_Authenticate' and not being able to login using our AD SSO environment. I've had an open call for about a year with Cognos on it, with no end in sight :) However, we just restart the services on a daily basis and I've never had any problems. Blom - Are you...

Go to settings and click on Get Data Later. It'll let you drop your dimensions in without having to calculate any measures. Todd

VE, There's different areas in healthcare reporting as well. Since you mentioned you had experience in finance reporting, you could go that route. Healthcare has finance systems to record charges, payments, adjustments, etc. that needs to be reported off of. Once you have experience there...

It's doable. If we do a report by dept for invoices, we would have one query that pulls only invoices starting with tr's and then another query that we just remove the filter (bringing all invoices). Then we combine those queries by joining on dept and use that query in the report. You would...

Hey Q, I see your point now...I've used a program called Monarch to parse "text reports" and it can usually skip over the odd carriage returns because you define the line. Then I output it in a text file to import into SQL. I'd see what your developer says, I've also heard that SQL has a...

Hey Q, I'm gonna second Blom's response. Just upload it into SQL and run your reports from there. That's most likely going to be easier then having your developers update their package. I've been in the same issue before, and sometimes it's just easier to upload it into SQL then have the...