Search results for query: *

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

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.

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.

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.

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.

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

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

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

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.

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

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

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

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.

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

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

One of the simplest questions you need to ask, is "how" the data needs to be secured or does it need to be secured. If it does, then you can start asking more in depth questions like mfgf brought up.

Because Transformer in C8 is Series 7 technology. PowerPlay web in some cases is still the better tool for most users. Analysis Studio is still new and lacks in some areas compared to PowerPlay Web, it's also harder to use for the basic end user, creating a much larger need for end user...

Mike, Why can't you? What will cause the results to be incorrect?

I can tell you this, you won't need any additional training for Transformer, Cognos 8 Transformer is Cognos 7.4 Transformer, and nothing much has really changed. Things got better, but nothing you couldn't handle. Check www.cognos.com and their services area, they may still offer what they...

Chandran, You would have to contact a sales rep for that one. They can give you acurate book pricing and any possible discounts you might have.