Hello colleagues,
I have another topic on my mind.
I would like to automatically redirect to a report when a certain criterion in a variable is met.
Have you ever had to implement something like this?
VG, Carmen
I had something similar but that won't work for this. The reports were pointed to read data from a different database depending on the value of a field in a table.
You can create the queries and pages from that different report into the same report which has the variable and execute those depending on the value of the variable using a render variable in a block or page.
Hello,
Basically, the variable is filled with the SQL statement as above. If the cube is not running, then a message is issued, which can be displayed or hidden via the output variable.
In addition to the message, there is only one custom control in the report that is also assigned the output variable. So this is only rendered when the cube is running.
The custom control then contains the forwarding.
define(function () {
"use strict";
function Control() {
};
Control.prototype.draw = function (oControlHost) {
window.open("https://cognosserver/ibmcognos/bi/?pathRef=.public_folders%2hboard", name="_top");
};
return Control;
});
The user receives the message that the cube is not running or the data is not available for another reason and for me it is crucial that the value comes from the database and can therefore be controlled by the ETL.
Greetings and thanks for the effort,
Carmen