Search results for query: *

Finaly I found the problem and can answer my above question. In the Impromtu definition of the catalog menu: Catalog-Databases I did not selected the correct ODBC connection name. Instead of that only "MS Access Database" was selected and for that the prompt for the source is understandable. I...

One addition to my notes: when adding the access db directly as a source in the transformer modell the problem is not occuring for that table. But I have to work with IQD´s...... and here its still a big problem. amac72

Dear Cognos Cracks, When including a IQD file (based on a report on an access 2000 database) as source in the transformer I allways have to specify the database position in the filesystem. This happens when using one of the following functions in COGNOS transformer: (Data source Viewer...

There is nothing to blame on cognos. I deleted the row in my script. My own fault :-) amac

I found a solution .. The solution would be to Copy the TransCont.inc file into the directory that contains the macro and use a '$Include "TranConst.inc" in the beginning of the code before the sub main () part. Regards, Amac

Dear cognos forum members, by trying to add a special category using a macro code I get the error message R440 "AutoExe: (Type) : Wrong argument value. Does anyone now more about this error message and what I have to do? The macro code is an example based on the Great outdoor Company mdl...

Thanks, gilles. I took a look in the mac documentation but have problems with the code to specify a single category. so I am stuck in the very beginning..... My particular question: What detail code do I have to put in a mac file, to modify the calculation rules of a category named...

Dear forum members, We want to load the calculation rules for calc. categories in the powerplay transformer from a database system, because these rules change over the time. To avoid manuel adaptation I am looking for the makro code, which is needed to modify the formular in a category. I have...

One correction: The calculation works, if for all items in the calculation rule values are stored in the fact table. In the case of a non existing of a fact record (e.g. for the measure id 113) the whole category is not shown in the powerplay cube. why?

Hi all, The model looks like a DIM table containing a measure hierarchy and the according fact table with one fact row holding the values for the measures in one single collumn. In the dimension I need to generate calculated categories on a high level. This is possible for categories which are...

Hi all, can you recommend any COGNOS (especially transformer/powerplay) books? I did not found any GOGNOS book on amazon .... [pc3] AMAC

Hi all, I am pretty new to the cognos transformer and the possible inclusion of security in cubes. For the following situation I am looking for your help: We need a security feature, that allows a web portal user (not upfront or any other cognops portal) to access only the cube data which is...