3) Difference between native sql and pass through sql
a)Both native and pass through sql cannot refere to any parameters of cognos.Native sql is fired directly on database and hav to be self contained . same for pass through sql .It also cannot use data from multiple data sources defined in model.
try using native sql for two schemas which has grant priviledges
b)Pass through sql allows you to use statements that are not valid inside a subquery such as order by . IT will not pass the sql as a single sql but it will pass both the statements separate and join in cognos .THat is both the query and subquery will be sent separately and joined in the cognos
{} curly brackets denote Native SQL.
{{}} double curly brackets denote passthrough SQL.
MDL (Model Definition Language) file format is a model saved in an ASCII file (its structure can be understood pretty easily). It is compatible between different version of transformer and can be edited in any text editor.
It takes more time to work with MDL files because when it is being opened, Transformer compiles it anyway in the background.
The biggest difference between PYI/PYJ and MDL file is that in the binary PYI file stores passwords to the datasources(usually database connections) and MDL file contains only an userid and password needs to be provided every time the cube is refreshed.
Problem solution:
In many cases, when users access cubes only locally with the PowerPlay client and there's no need to apply the security at all, it can be removed. To see if the security classes is applied, just have a look at the 'User classes' panel in the PowerPlay Transformer and check if there are any entries.
To remove security from the model and the cube go to File -> Model Properties... -> Authentication and uncheck the Include Acces Manager user classes in the model box.
To bring back the authentication classes choose the Access manager configuration from a dropdown list and drag & drop the corresponding user classes to the powercube area.
When the security should be applied in the cubes, then you must review the authentication. Have a look at the access manager, rebuild the user classes when propmptet and compare with PowerPlay clients installed on different machines.
To see the authentication settings go to configuration manager, open the current configuration and verify options in the Services -> Access Manager - Directory Server -> General menu.
----------------------------------------------------------------------
Check whether the model has a category with more than 65536 children in the source data. If this is the case, modify the source so that it breaks down the children into several subcategories.
-----------------------------------------------------------------------------------
How to run CognosScript macros written in CognosScipt
CognosScript programs (macros) can be written, run, debugged and tested in the CognosScript Editor which comes with the installation of Cognos PowerPlay.
The PowerPlay Macros are saved to a text format and have a mac extension. When the file is run it is automatically compiled to a binary file with has a mcx extension.
Once the script is saved, tested and works stable, it is very likely that there will be a need to run it from the command line. There is a program called runmac32.exe in the \bin\ cognos installation folder which makes it possible to run cognosscipt macros externally.
To run a cognos macro from the command line just type in the following at the command prompt:
"C:\Program Files\Cognos\cer3\bin\runmac32.exe" D:\script.mac
It is also possible to pass a parameter to the script (you'll find an example on how to read the parameter in CognosScript on our pages). It can be done by adding the parameter simply at the end of the command: "C:\Program Files\Cognos\cer3\bin\runmac32.exe" D:\script.mac string_parameter
--------------------------------------------------------------------------------------------------------
It is possible to drill through from PowerPlay to:
other PowerCubes
PowerPlay reports
Cognos 8 applications and Cognos Impromptu report
CognosScript macro files
Microsoft Office files(doc, xls, ppt)
Where to Find log files for Transformer.
Usually when you build a cube a transformer folder will be created in your my folders it has log folder under it
a)Both native and pass through sql cannot refere to any parameters of cognos.Native sql is fired directly on database and hav to be self contained . same for pass through sql .It also cannot use data from multiple data sources defined in model.
try using native sql for two schemas which has grant priviledges
b)Pass through sql allows you to use statements that are not valid inside a subquery such as order by . IT will not pass the sql as a single sql but it will pass both the statements separate and join in cognos .THat is both the query and subquery will be sent separately and joined in the cognos
{} curly brackets denote Native SQL.
{{}} double curly brackets denote passthrough SQL.
Cognos models file extensions - pyg, pyh, pyi, mdl, pyj
The PYH and PYI models are compiled to a binary format and are Cognos series 7 version specific. IBM Cognos 8 uses a PYJ file format. Models stored in the binary format are generally quicker to open and refresh.MDL (Model Definition Language) file format is a model saved in an ASCII file (its structure can be understood pretty easily). It is compatible between different version of transformer and can be edited in any text editor.
It takes more time to work with MDL files because when it is being opened, Transformer compiles it anyway in the background.
The biggest difference between PYI/PYJ and MDL file is that in the binary PYI file stores passwords to the datasources(usually database connections) and MDL file contains only an userid and password needs to be provided every time the cube is refreshed.
Problem solution:
In many cases, when users access cubes only locally with the PowerPlay client and there's no need to apply the security at all, it can be removed. To see if the security classes is applied, just have a look at the 'User classes' panel in the PowerPlay Transformer and check if there are any entries.
To remove security from the model and the cube go to File -> Model Properties... -> Authentication and uncheck the Include Acces Manager user classes in the model box.
To bring back the authentication classes choose the Access manager configuration from a dropdown list and drag & drop the corresponding user classes to the powercube area.
When the security should be applied in the cubes, then you must review the authentication. Have a look at the access manager, rebuild the user classes when propmptet and compare with PowerPlay clients installed on different machines.
To see the authentication settings go to configuration manager, open the current configuration and verify options in the Services -> Access Manager - Directory Server -> General menu.
----------------------------------------------------------------------
Check whether the model has a category with more than 65536 children in the source data. If this is the case, modify the source so that it breaks down the children into several subcategories.
-----------------------------------------------------------------------------------
How to run CognosScript macros written in CognosScipt
CognosScript programs (macros) can be written, run, debugged and tested in the CognosScript Editor which comes with the installation of Cognos PowerPlay.
The PowerPlay Macros are saved to a text format and have a mac extension. When the file is run it is automatically compiled to a binary file with has a mcx extension.
Once the script is saved, tested and works stable, it is very likely that there will be a need to run it from the command line. There is a program called runmac32.exe in the \bin\ cognos installation folder which makes it possible to run cognosscipt macros externally.
To run a cognos macro from the command line just type in the following at the command prompt:
"C:\Program Files\Cognos\cer3\bin\runmac32.exe" D:\script.mac
It is also possible to pass a parameter to the script (you'll find an example on how to read the parameter in CognosScript on our pages). It can be done by adding the parameter simply at the end of the command: "C:\Program Files\Cognos\cer3\bin\runmac32.exe" D:\script.mac string_parameter
--------------------------------------------------------------------------------------------------------
It is possible to drill through from PowerPlay to:
other PowerCubes
PowerPlay reports
Cognos 8 applications and Cognos Impromptu report
CognosScript macro files
Microsoft Office files(doc, xls, ppt)
Where to Find log files for Transformer.
Usually when you build a cube a transformer folder will be created in your my folders it has log folder under it
No comments:
Post a Comment