cancel
Showing results for 
Search instead for 
Did you mean: 

Hide and Show

0 Kudos

Hi, I have two table in the universe both are not joined and no common key as well so i can't join. 1 Table A 2 Table B Table A having ETL Load date. My Requirement: If ETL load date and Userresponse date(Prompt Value) is same then Table B should show else Table B should hide. Logic: I am writing the Table B Block level =if (ETL Load date = USerresponse date) ;1;0 then if the value is 0 then hide the block =(if (ETL Load date = USerresponse date) ;1;0)=0 Can you please help me how to achieve, due to Datasync error this is not working. Any work around, trying with Union in universe level and report level no luck Basically i want to show the report only if current month data is available in the database. Thanks,

Accepted Solutions (1)

Accepted Solutions (1)

kohesco
Active Contributor
0 Kudos

hi create variables for your dates and display them as free cells -> check the outcome -> probably your dates formats will not match -> try to re-format one of them so they match

Answers (1)

Answers (1)

Former Member
0 Kudos

Hello Vsenni

In my experience you sometimes have to fiddle around with building variables that will make the calculation context work.

Try defining variables for:

var 1= user response (measure)

Var 2=ETL load date (measure)

var 3= If var 1=var 2 then 1 else 0 (measure)

And then use var 3 for the block rule.

No guarantees!

Regards, Henrik