topic Re: Problem with tables not attached in Management & Governance

Problem with tables not attached

zied_ahmed1 — Fri, 24 Aug 2018 13:54:58 GMT

Hello,

I have two tables :

first table name Exist_Not Exist ( we have two fields Exist , Not Exist )

Second table named Objects (Car Name, Statut)

The problem is i cant attached the two tables

and this is the structure for fields :

i need to when in Exist we select Statut we have directly to select 1 in the field statut and display only the car Names who have Statut = 1

(I need to do this with variables for exemples not in script )

Thanks for help

omarbensalem‌

Re: Problem with tables not attached

joseph_eftamand — Fri, 24 Aug 2018 14:03:06 GMT

Not sure I understand you correctly, apologies If I misunderstood your query. When loaded in the script in order to build the associations between tables, they need to share a field of the same name. This will usually be some kind id which can associate a fact table to various dimension tables. If you can provide the tables you are trying to associate then that would make the explanation easier.

Re: Problem with tables not attached

zied_ahmed1 — Fri, 24 Aug 2018 14:08:46 GMT

I can't touch the code that's the problem , so i need to use some variables and condition to do it

Re: Problem with tables not attached

breno_morais — Fri, 24 Aug 2018 14:38:49 GMT

Can you attach sample application? I can't understand what you need.

Re: Problem with tables not attached

OmarBenSalem — Sun, 26 Aug 2018 21:15:08 GMT

Use set expressions.

Sthnng like, if(Exist='Statut',sum({<Statut={1}>}measure),sum(measure))

Re: Problem with tables not attached

Anders_Eriksson — Mon, 27 Aug 2018 07:55:28 GMT

Set analysis is a good solution but your example is not.
Both Sum-statements and the if-statement will be executed for every row in the table.
The if should be placed in a $-expansion inside the set analysis.
Like this: Sum({$<$(if(Exist='Statut', 'Statut={1}', '')>} measure)

Set analysis is executed once for the whole table and we have only one expression calculated for each row.

A small table with limited data it makes no difference but in large applications it does.

Re: Problem with tables not attached

zied_ahmed1 — Mon, 27 Aug 2018 08:37:00 GMT

Hello everybody,

Thanks for your answers. I attached an example of the application.Just one thing when I selected Color in Exist I can't select it in not exist

so now for example when I select color in Exist and Entreprise in not exist I will have a table with just one row with the hostname X

Hope you understand how I need to do

Thanks

Re: Problem with tables not attached

breno_morais — Mon, 27 Aug 2018 14:24:00 GMT

Hi Zied,

I'm studying your case and I finded until moment this expression in Statut dimension on chart:

=if(match(Exist,'Statut'), if(match(Statut,'1'), Statut, Null()), Statut)

Later I will back to the case, if this information will help you, pls mark HELPFUL

Good luck