Recent Posts

Pages: [1] 2 3 ... 10
1
Dashboards / Re: Navigation path - Validation issues
« Last post by MFGF on Today at 09:29:39 am »
I've been looking into this further and I've been able to replicate the issue with the Samples packages.
It appears at present that if i create a navigation path when using a published package as a data source (no modules) it always generates a validation error.
For example I just created a new dashboard and then a navigation path using GO SALES(Query).

Into the navigation path i dragged branch code, Address 1, Address 2 and City.

I'm updating my ticket with IBM but the following are the validation issues that then occur.




{msg: [{severity: "info", text: "Total number of errors: 4, warnings: 0"},…], data: {,…}}
data
:
{,…}
validationMessage
:
[{severity: "error",…}, {severity: "error",…}, {severity: "error",…}, {severity: "error",…}]
0
:
{severity: "error",…}
errorCode
:
"MSR-VRF-1116"
location
:
"./drillGroup[1]/segment[1]/"
msg
:
"MSR-VRF-1116 The column "Branch code" refers to "[Inventory (query)].[Branch].[Branch code]", which does not exist. Remove the column "Branch code" from the navigation group."
ruleId
:
"com.ibm.bi.validation.rule.reference"
severity
:
"error"
type
:
"reference"
1
:
{severity: "error",…}
errorCode
:
"MSR-VRF-1116"
location
:
"./drillGroup[1]/segment[2]/"
msg
:
"MSR-VRF-1116 The column "Address 1" refers to "[Inventory (query)].[Branch].[Address 1]", which does not exist. Remove the column "Address 1" from the navigation group."
ruleId
:
"com.ibm.bi.validation.rule.reference"
severity
:
"error"
type
:
"reference"
2
:
{severity: "error",…}
3
:
{severity: "error",…}
msg
:
[{severity: "info", text: "Total number of errors: 4, warnings: 0"},…]

That does sound to me like a defect. I'll see if I can re-create it to confirm it's not something specific to your instance, but having an open ticket with IBM is the best way forward I think.

Cheers!

MF.
2
Dashboards / Re: Navigation path - Validation issues
« Last post by cognosjon on Today at 08:21:10 am »
I've been looking into this further and I've been able to replicate the issue with the Samples packages.
It appears at present that if i create a navigation path when using a published package as a data source (no modules) it always generates a validation error.
For example I just created a new dashboard and then a navigation path using GO SALES(Query).

Into the navigation path i dragged branch code, Address 1, Address 2 and City.

I'm updating my ticket with IBM but the following are the validation issues that then occur.




{msg: [{severity: "info", text: "Total number of errors: 4, warnings: 0"},…], data: {,…}}
data
:
{,…}
validationMessage
:
[{severity: "error",…}, {severity: "error",…}, {severity: "error",…}, {severity: "error",…}]
0
:
{severity: "error",…}
errorCode
:
"MSR-VRF-1116"
location
:
"./drillGroup[1]/segment[1]/"
msg
:
"MSR-VRF-1116 The column "Branch code" refers to "[Inventory (query)].[Branch].[Branch code]", which does not exist. Remove the column "Branch code" from the navigation group."
ruleId
:
"com.ibm.bi.validation.rule.reference"
severity
:
"error"
type
:
"reference"
1
:
{severity: "error",…}
errorCode
:
"MSR-VRF-1116"
location
:
"./drillGroup[1]/segment[2]/"
msg
:
"MSR-VRF-1116 The column "Address 1" refers to "[Inventory (query)].[Branch].[Address 1]", which does not exist. Remove the column "Address 1" from the navigation group."
ruleId
:
"com.ibm.bi.validation.rule.reference"
severity
:
"error"
type
:
"reference"
2
:
{severity: "error",…}
3
:
{severity: "error",…}
msg
:
[{severity: "info", text: "Total number of errors: 4, warnings: 0"},…]
3
Ah, now I understand! The dilemma of case conversion with a mutli-select text box prompt makes more sense.

You could try using a prompt macro for your filter expression.

Code: [Select]
[Your Data Item] in ( #toupper( promptmany('YourParameter') )# )

The innermost portion "promptmany('YourParameter')" is equivalent to using "?YourParameter?" syntax.

The outer portion converts the resulting string to upper case. You can find these and other macro functions in the Macros tab of the expression editor.
4
HI Friends ,

Please consider as High priority

I would like to start the installation using existing content store ( C10 content store connecting to C11)
We have 2 fresh servers one   is Webserver and another one is Application server
Now how do I install the components i.e Data tier, App tier can be in same folder at a time?
or  CM and APP on separate folder location on the same Server, and  anyway optional gate way components will install  on webserver.
What difference  we  can see if we install the CM and APP on separate folder location on the same Server
Or at onetime we install the same folder location together CM and APP? is there any performance issues will occur ?  Please consider as High priority
5
Reporting / Re: Pattern strings in Cognos macros
« Last post by BlueSky on Today at 06:48:40 am »
I need to generate a LIKE statement in a piece of native SQL (we have some non-Cognos supported functions so have no choice to use native SQL, long story...).

The macro currently looks like this and is used in the WHERE clause:

WHERE
#join(' or ',substitute('^','"Location_Path" like ',split(',',promptmany('LocationIncl'))))#

..which translates to:

WHERE
"Location_Path" like 'Europe' or "Location_Path" like  'America'

..however to be a correct 'starts with' LIKE I need each string in the array to end with a % i.e.

WHERE
"Location_Path" like 'Europe%' or "Location_Path" like  'America%'

Using a regular expression, the function would look like:

#join(' or ',substitute('^','"Location_Path" like ',substitute('.$',sq('%'''),split(',',promptmany('LocationIncl')))))#

.$ is the regular expression to find the position of the final character (single quote) and replace with %'.  However it seems this regex is not supported.  So was wondering if there was a list of supported pattern strings for use in Cognos macros?  Or another way of doing this?
6
Hello,

we would like to know if anyone tried to open a folder (popup the content of specified folder) in the navigation bar from a link included in the report defined as home tab.

Something like in attached picture. Having many folders with reports with complicated structure, the purpose is to create a report as a library of report folder links presented in easy structure and set as home for users.
We can achieve this by adding the URL link for these folders in the report, but this open the link always as new tab using home perspective. We would like to just popup the folder content on the left navigation bar without re executing like when you normally browse the folders in navigation bar.

Does someone tried this, do you think is reachable? Even by writing own view or via JS?

Thank you

7
Hi,

a content manager is not the same like a dispatcher. The content manager is the one Cognos application server that writes into the content store which is why there is only one active at all times.

When you turn on any application server it searches for the content manager. If it is one itself then it checks if there is another active one. If not then it assumes that role itself. I guess this sequence is kept even in an single server installation.

A dispatcher is a Cognos server that directs requests to dispatchers with the appropriate Cognos services running.

So if a report should be executed the gateway sends it to one of its dispatchers by round robin. If that one has the reporting and query service running it will do the job itself. Otherwise it sends the request to another dispatcher.
8
COGNOS 8 Administration / Re: DPR-ERR-2079 Firewall Security Rejection.
« Last post by shli on Today at 03:33:58 am »
I found there also have this issue :
DPR-ERR-2079 Firewall Security Rejection when you login out the cognos after open one report studio, when save, it will report such errors.
So just reopen the report studio after relogin , then save, it works.
9
Administration and Security / Re: Cognos Issue with Google Chrome
« Last post by Lynn on Today at 01:58:08 am »
Perhaps browser cache should be cleared?
10
Report Studio / Re: report studio
« Last post by BigChris on Today at 01:58:02 am »
Pages: [1] 2 3 ... 10

       
Twittear