Formula Columns not working in the Alias table

[Maran_Rengasamy]

Hi,

I have created a Alias table and using it in my report. The Formula Columns in the base table not showing any values in my report. 

If I use the Base table in Report, the formula columns showing the correct values.

Any idea on this issue? Is there any sync issue need to be addressed?

Thanks

[RADSr]

What do your joins look like?  

If you can't share the actual diagram can you mock up an example using the Onlinestore schema?  

The more info the better! 

[Maran_Rengasamy]

Hi RADSr,

There is no join in the Alias table.

Created a formula columns in base table and loaded(full) the table.

Then created a Alias table and used it in the report.

[RADSr · Accepted solution]

Ah - my misunderstanding.   

The alias table should inherit parent joins but not child - are the columns appearing w/ no values, or are the columns not showing up at all?   ( they should show up ).

Any other tables involved?   Filters?  Measure filters?    My go-to next step would be to review the SQL from as simple an insight as I could make reproducing the issue.

[Maran_Rengasamy]

Hi RADSr,

I found the issue. Earlier I added a join and then removed. somehow the Join reference is not removed properly. The Query Plan showed the Join reference. So I recreated the Alias table and it's working fine now.

Thanks for your time on this issue.