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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by CognosChicago

  1. CognosChicago

    Cognos 8 - Cube Rebuild

    Cognos8 actually used Transformer 7.4 to build cubes, even though it has been branded as Cognos8.
  2. CognosChicago

    Transformer not shutting down

    You should be able to modify it to fit into VBScript, no reason you shouldn't that I can think of. Play around with it and see if there are syntax errors in your VBScript from the cognos specific portions.
  3. CognosChicago

    Report Studio Question

    Mike, It certainly takes getting used to that is for sure, but once you do I think you will see it's benefits and how you have much more control over the query, the objects in the report, and the overall process.
  4. CognosChicago

    Report Studio Question

    I don't suggest cutting anything. The approch mfgf gave above is the correct technique for C8, or writing the query first and then populating the report output manually. I think most hard core Report Studio report authors are going to author the query first and then the report second.
  5. CognosChicago

    Transformer not shutting down

    I don't see why not. It was written using the CognosScript editor, but it's pretty straight forward code. The objects are Cognos Transformer specific objects and should be available to use in VBScript or VB Code. All you can do is try.
  6. CognosChicago

    Report Studio Question

    Mike, What version of Report Studio are you using, ReportNet 1.1 or C8? Not that it makes much difference, but the interfaces are different enough. In 1.1 for every report you have queries, obviously, and each query can have a tabular model. In the query or the tablular model you can create...
  7. CognosChicago

    what is preference on Procedure VS. Straight pass-through

    They may just render an error. Let's say you have params you want passed to the SP, pretty common thing to do. If you change anything about the params you need to fix it in the FM model and republish. The FM model is only as good as the last time it published. At the same time if you make...
  8. CognosChicago

    Transformer not shutting down

    Here you go, a written and tested script, just change things were neccessary, like path and model name and extension (I prefer mdl's over py?'s): Sub Main Dim lo_objTransApp as Object Dim lo_objModel as Object Set lo_objTransApp = CreateObject("CognosTransformer.Application")...
  9. CognosChicago

    what is preference on Procedure VS. Straight pass-through

    SP's can be great, but just remember, you might have to go back and republish your FM model every time you make a change to the SP. Not that this is a problem, just something to remember.
  10. CognosChicago

    Transformer not shutting down

    Try this instead: Set go_objTransApp = CreateObject("CognosTransformer.Application") Set go_objModel = go_objTransApp.OpenModel(location\modelname.py? or mdl) go_objModel.CreateMDCFiles go_objModel.Close Set go_objModel = Nothing Set go_objTransApp = Nothing This isn't a script by any...
  11. CognosChicago

    Merge the contents of 3 tables into 1 table

    Steve, Are you asking how to do this in VB or just how to do this in general? John, don't be so harsh!
  12. CognosChicago

    Publishing Cubes in Cognos 8

    Keep in mind if you are using C8 or PPES 7.4 to deliver your cubes, Transformer is 7.4 either way, so the cube is no different. The difference is how do you want to get the information to the end user, via C8 or PPES. PPEs is a lot less fancy and C8's Cognos GO Office is fancy, but they both...
  13. CognosChicago

    Cognos 8 courses

    I think heading to a Cognos training center will be your best bet in this case. You will get more information from them than anyone else in a short period of time.
  14. CognosChicago

    Data Modeling

    Not that I would, but you can duplicate what is done in the Impromptu Catalog in FM. If it works and it does what the client wants, then you might just have to do that. You can keep things much cleaner inside FM than Impromptu Admin, but still use the same concepts. I'm going to have a...
  15. CognosChicago

    Data Modeling

    Mike, I think you can get the right answers out of a OLTP, if you couldn't what use would they be to anyone. I think you might need to create more shortcuts to tables so you can create extra relationships between tables, but it can be done. I've been working with OLTP's for years and...
See more

Part and Inventory Search

Back
Top