Hello,

To know if I need to run a sub process, I want to create a view in the data procedure. If the view dont have data, I dont need to run the sub process. But it's look that it's not possible in TI to get this information. It will be great to have a function that give the non empty count for a MDX expression.

------------------------------
christophe Baudouin
------------------------------

AFAIK there is no built-in function to achieve this.

I assume you want to loop that view in your sub process. I can think of 2 ways of doing this:

1. Pick a dimension which would serve as a "value" indicator. Create a subset where you would filter the elements based on some cube value. Check the subset size
2. Create a view and set zero suppression ON. Call the sub process and use the view as a data source. If the view contains no data, the Metadata and Data tabs will be skipped

------------------------------
Vlad Didenko
Founder at Succeedium
TeamOne Google Sheets add-on for IBM Planning Analytics / TM1
https://succeedium.com/teamone/
------------------------------

Original Message:
Sent: Fri February 10, 2023 02:52 AM
From: christophe Baudouin
Subject: Getting number of row in turbointegrator

Hello,

To know if I need to run a sub process, I want to create a view in the data procedure. If the view dont have data, I dont need to run the sub process. But it's look that it's not possible in TI to get this information. It will be great to have a function that give the non empty count for a MDX expression.

------------------------------
christophe Baudouin
------------------------------

Hi Christophe,

I do not think there is a TI function which counts the non-empty cells in a cube view. However, you can create a cube view by MDX and pass it to a sub process to check whether the view is empty or not like what Vlad said. Alternatively, you can create the view in the sub process, and the sub process will also find a non-empty cell.

Do you have a particular reason why you do not want to run a sub process?

Thanks,

Kong

------------------------------
Kong Intrasinghathong
Master Consultant
QueBIT Consulting
https://quebit.com
------------------------------

Original Message:
Sent: Fri February 10, 2023 02:52 AM
From: christophe Baudouin
Subject: Getting number of row in turbointegrator

Hello,

To know if I need to run a sub process, I want to create a view in the data procedure. If the view dont have data, I dont need to run the sub process. But it's look that it's not possible in TI to get this information. It will be great to have a function that give the non empty count for a MDX expression.

------------------------------
christophe Baudouin
------------------------------