Cognos Analytics

Hello,
do you have some tip how to block a drill through functionallity when you click on a number in a report and full interactivity mode is enabled?
Thank you!
Regards,
L.

------------------------------
Lubomir Jungwirth
------------------------------

#CognosAnalyticswithWatson

I'm not sure if this is possible, but I would need a bit more detail to further investigate. Are you using a List or Crosstab Container? To confirm, you would like to disable drill-through on a specific column/? or you would like to disable drill-through on all facts/measure and only be able to drill-through on your dimensions?

------------------------------
DENNY NAREZNY
------------------------------

Original Message:
Sent: 02-28-2019 08:32 AM
From: Lubomir Jungwirth
Subject: Drill through functionality

Hello,
do you have some tip how to block a drill through functionallity when you click on a number in a report and full interactivity mode is enabled?
Thank you!
Regards,
L.

------------------------------
Lubomir Jungwirth
------------------------------

#CognosAnalyticswithWatson

Thanks for the response.
We use crosstab container and we would like to disable drill through functionality on all facts/measures. The drill through functionality should be still enabled on dimensions.

------------------------------
Lubomir Jungwirth
------------------------------

Original Message:
Sent: 03-08-2019 09:37 AM
From: DENNY NAREZNY
Subject: Drill through functionality

I'm not sure if this is possible, but I would need a bit more detail to further investigate. Are you using a List or Crosstab Container? To confirm, you would like to disable drill-through on a specific column/? or you would like to disable drill-through on all facts/measure and only be able to drill-through on your dimensions?

------------------------------
DENNY NAREZNY

Original Message:
Sent: 02-28-2019 08:32 AM
From: Lubomir Jungwirth
Subject: Drill through functionality

Hello,
do you have some tip how to block a drill through functionallity when you click on a number in a report and full interactivity mode is enabled?
Thank you!
Regards,
L.

------------------------------
Lubomir Jungwirth
------------------------------

#CognosAnalyticswithWatson

Hi Lobomir,

When creating a crosstab in a report in edit mode, the report author creates the drill through definition separately for each dimension node and the fact/measure cells (in edit mode, see the properties of the cross tab nodes vs fact cells). If you do not set the drill through definition on the fact/measure cell, it should not have drill through functionality on the facts even in full interactivity mode. What version are you on? I just tested this on 11.1 FP1, and it works. I'm wondering if you are seeing a defect in the version you are using.

Or are you trying to prevent report authors from being able to create the drill through definition on facts/measures in the report in edit mode in the first place? That is a different scenario altogether.

------------------------------
Katie McCray
------------------------------

Original Message:
Sent: 03-11-2019 02:55 AM
From: Lubomir Jungwirth
Subject: Drill through functionality

Thanks for the response.
We use crosstab container and we would like to disable drill through functionality on all facts/measures. The drill through functionality should be still enabled on dimensions.

------------------------------
Lubomir Jungwirth

Original Message:
Sent: 03-08-2019 09:37 AM
From: DENNY NAREZNY
Subject: Drill through functionality

I'm not sure if this is possible, but I would need a bit more detail to further investigate. Are you using a List or Crosstab Container? To confirm, you would like to disable drill-through on a specific column/? or you would like to disable drill-through on all facts/measure and only be able to drill-through on your dimensions?

------------------------------
DENNY NAREZNY

Original Message:
Sent: 02-28-2019 08:32 AM
From: Lubomir Jungwirth
Subject: Drill through functionality

Hello,
do you have some tip how to block a drill through functionallity when you click on a number in a report and full interactivity mode is enabled?
Thank you!
Regards,
L.

------------------------------
Lubomir Jungwirth
------------------------------

#CognosAnalyticswithWatson

Hi Katie,
probably I didn't find the settings which you mentioned in your post. Please see the attachement where you can see which options I see when I select Crosstab or Crosstab intersection in edit mode. I also added report design with comments. The report is based on dimensional data.
Thanks and regards,
Lubomir


------------------------------
Lubomir Jungwirth
------------------------------

Original Message:
Sent: 03-11-2019 08:03 AM
From: Katie McCray
Subject: Drill through functionality

Hi Lobomir,

When creating a crosstab in a report in edit mode, the report author creates the drill through definition separately for each dimension node and the fact/measure cells (in edit mode, see the properties of the cross tab nodes vs fact cells). If you do not set the drill through definition on the fact/measure cell, it should not have drill through functionality on the facts even in full interactivity mode. What version are you on? I just tested this on 11.1 FP1, and it works. I'm wondering if you are seeing a defect in the version you are using.

Or are you trying to prevent report authors from being able to create the drill through definition on facts/measures in the report in edit mode in the first place? That is a different scenario altogether.

------------------------------
Katie McCray

Original Message:
Sent: 03-11-2019 02:55 AM
From: Lubomir Jungwirth
Subject: Drill through functionality

Thanks for the response.
We use crosstab container and we would like to disable drill through functionality on all facts/measures. The drill through functionality should be still enabled on dimensions.

------------------------------
Lubomir Jungwirth

Original Message:
Sent: 03-08-2019 09:37 AM
From: DENNY NAREZNY
Subject: Drill through functionality

I'm not sure if this is possible, but I would need a bit more detail to further investigate. Are you using a List or Crosstab Container? To confirm, you would like to disable drill-through on a specific column/? or you would like to disable drill-through on all facts/measure and only be able to drill-through on your dimensions?

------------------------------
DENNY NAREZNY

Original Message:
Sent: 02-28-2019 08:32 AM
From: Lubomir Jungwirth
Subject: Drill through functionality

Hello,
do you have some tip how to block a drill through functionallity when you click on a number in a report and full interactivity mode is enabled?
Thank you!
Regards,
L.

------------------------------
Lubomir Jungwirth
------------------------------

#CognosAnalyticswithWatson

Hello Lubomir,

Thanks for providing the screenshots. As long as you do not have a drill-through definition setup on the Fact Cells, you should not be able to drill-through on any of the measures (Screenshot Attached). Unless you are talking about Drill-up and Drill-down and not Drill-through?

------------------------------
DENNY NAREZNY
------------------------------

Original Message:
Sent: 03-12-2019 08:16 AM
From: Lubomir Jungwirth
Subject: Drill through functionality

Hi Katie,
probably I didn't find the settings which you mentioned in your post. Please see the attachement where you can see which options I see when I select Crosstab or Crosstab intersection in edit mode. I also added report design with comments. The report is based on dimensional data.
Thanks and regards,
Lubomir


------------------------------
Lubomir Jungwirth

Original Message:
Sent: 03-11-2019 08:03 AM
From: Katie McCray
Subject: Drill through functionality

Hi Lobomir,

When creating a crosstab in a report in edit mode, the report author creates the drill through definition separately for each dimension node and the fact/measure cells (in edit mode, see the properties of the cross tab nodes vs fact cells). If you do not set the drill through definition on the fact/measure cell, it should not have drill through functionality on the facts even in full interactivity mode. What version are you on? I just tested this on 11.1 FP1, and it works. I'm wondering if you are seeing a defect in the version you are using.

Or are you trying to prevent report authors from being able to create the drill through definition on facts/measures in the report in edit mode in the first place? That is a different scenario altogether.

------------------------------
Katie McCray

Original Message:
Sent: 03-11-2019 02:55 AM
From: Lubomir Jungwirth
Subject: Drill through functionality

Thanks for the response.
We use crosstab container and we would like to disable drill through functionality on all facts/measures. The drill through functionality should be still enabled on dimensions.

------------------------------
Lubomir Jungwirth

Original Message:
Sent: 03-08-2019 09:37 AM
From: DENNY NAREZNY
Subject: Drill through functionality

I'm not sure if this is possible, but I would need a bit more detail to further investigate. Are you using a List or Crosstab Container? To confirm, you would like to disable drill-through on a specific column/? or you would like to disable drill-through on all facts/measure and only be able to drill-through on your dimensions?

------------------------------
DENNY NAREZNY

Original Message:
Sent: 02-28-2019 08:32 AM
From: Lubomir Jungwirth
Subject: Drill through functionality

Hello,
do you have some tip how to block a drill through functionallity when you click on a number in a report and full interactivity mode is enabled?
Thank you!
Regards,
L.

------------------------------
Lubomir Jungwirth
------------------------------
#CognosAnalyticswithWatson

Hello Denny,
thank you. From this point of view I mean drill-down instead of drill-through. Is it possible to block this functionality?
Thanks,

------------------------------
Lubomir Jungwirth
------------------------------

Original Message:
Sent: 03-12-2019 01:31 PM
From: DENNY NAREZNY
Subject: Drill through functionality

Hello Lubomir,

Thanks for providing the screenshots. As long as you do not have a drill-through definition setup on the Fact Cells, you should not be able to drill-through on any of the measures (Screenshot Attached). Unless you are talking about Drill-up and Drill-down and not Drill-through?

------------------------------
DENNY NAREZNY

Original Message:
Sent: 03-12-2019 08:16 AM
From: Lubomir Jungwirth
Subject: Drill through functionality

Hi Katie,
probably I didn't find the settings which you mentioned in your post. Please see the attachement where you can see which options I see when I select Crosstab or Crosstab intersection in edit mode. I also added report design with comments. The report is based on dimensional data.
Thanks and regards,
Lubomir


------------------------------
Lubomir Jungwirth

Original Message:
Sent: 03-11-2019 08:03 AM
From: Katie McCray
Subject: Drill through functionality

Hi Lobomir,

When creating a crosstab in a report in edit mode, the report author creates the drill through definition separately for each dimension node and the fact/measure cells (in edit mode, see the properties of the cross tab nodes vs fact cells). If you do not set the drill through definition on the fact/measure cell, it should not have drill through functionality on the facts even in full interactivity mode. What version are you on? I just tested this on 11.1 FP1, and it works. I'm wondering if you are seeing a defect in the version you are using.

Or are you trying to prevent report authors from being able to create the drill through definition on facts/measures in the report in edit mode in the first place? That is a different scenario altogether.

------------------------------
Katie McCray

Original Message:
Sent: 03-11-2019 02:55 AM
From: Lubomir Jungwirth
Subject: Drill through functionality

Thanks for the response.
We use crosstab container and we would like to disable drill through functionality on all facts/measures. The drill through functionality should be still enabled on dimensions.

------------------------------
Lubomir Jungwirth

Original Message:
Sent: 03-08-2019 09:37 AM
From: DENNY NAREZNY
Subject: Drill through functionality

I'm not sure if this is possible, but I would need a bit more detail to further investigate. Are you using a List or Crosstab Container? To confirm, you would like to disable drill-through on a specific column/? or you would like to disable drill-through on all facts/measure and only be able to drill-through on your dimensions?

------------------------------
DENNY NAREZNY

Original Message:
Sent: 02-28-2019 08:32 AM
From: Lubomir Jungwirth
Subject: Drill through functionality

Hello,
do you have some tip how to block a drill through functionallity when you click on a number in a report and full interactivity mode is enabled?
Thank you!
Regards,
L.

------------------------------
Lubomir Jungwirth
------------------------------
#CognosAnalyticswithWatson

Hello Lubomir,
Thanks for the clarification. It does not look possible to disable drill-down on cells in a crosstab. I would suggest logging - https://www-01.ibm.com/support/docview.wss?uid=swg21998358

------------------------------
DENNY NAREZNY
------------------------------

Original Message:
Sent: 03-15-2019 05:44 AM
From: Lubomir Jungwirth
Subject: Drill through functionality

Hello Denny,
thank you. From this point of view I mean drill-down instead of drill-through. Is it possible to block this functionality?
Thanks,

------------------------------
Lubomir Jungwirth

Original Message:
Sent: 03-12-2019 01:31 PM
From: DENNY NAREZNY
Subject: Drill through functionality

Hello Lubomir,

Thanks for providing the screenshots. As long as you do not have a drill-through definition setup on the Fact Cells, you should not be able to drill-through on any of the measures (Screenshot Attached). Unless you are talking about Drill-up and Drill-down and not Drill-through?

------------------------------
DENNY NAREZNY

Original Message:
Sent: 03-12-2019 08:16 AM
From: Lubomir Jungwirth
Subject: Drill through functionality

Hi Katie,
probably I didn't find the settings which you mentioned in your post. Please see the attachement where you can see which options I see when I select Crosstab or Crosstab intersection in edit mode. I also added report design with comments. The report is based on dimensional data.
Thanks and regards,
Lubomir


------------------------------
Lubomir Jungwirth

Original Message:
Sent: 03-11-2019 08:03 AM
From: Katie McCray
Subject: Drill through functionality

Hi Lobomir,

When creating a crosstab in a report in edit mode, the report author creates the drill through definition separately for each dimension node and the fact/measure cells (in edit mode, see the properties of the cross tab nodes vs fact cells). If you do not set the drill through definition on the fact/measure cell, it should not have drill through functionality on the facts even in full interactivity mode. What version are you on? I just tested this on 11.1 FP1, and it works. I'm wondering if you are seeing a defect in the version you are using.

Or are you trying to prevent report authors from being able to create the drill through definition on facts/measures in the report in edit mode in the first place? That is a different scenario altogether.

------------------------------
Katie McCray

Original Message:
Sent: 03-11-2019 02:55 AM
From: Lubomir Jungwirth
Subject: Drill through functionality

Thanks for the response.
We use crosstab container and we would like to disable drill through functionality on all facts/measures. The drill through functionality should be still enabled on dimensions.

------------------------------
Lubomir Jungwirth

Original Message:
Sent: 03-08-2019 09:37 AM
From: DENNY NAREZNY
Subject: Drill through functionality

I'm not sure if this is possible, but I would need a bit more detail to further investigate. Are you using a List or Crosstab Container? To confirm, you would like to disable drill-through on a specific column/? or you would like to disable drill-through on all facts/measure and only be able to drill-through on your dimensions?

------------------------------
DENNY NAREZNY

Original Message:
Sent: 02-28-2019 08:32 AM
From: Lubomir Jungwirth
Subject: Drill through functionality

Hello,
do you have some tip how to block a drill through functionallity when you click on a number in a report and full interactivity mode is enabled?
Thank you!
Regards,
L.

------------------------------
Lubomir Jungwirth
------------------------------
#CognosAnalyticswithWatson