topic Re: Formula Columns not working in the Alias table in Data & Schema Discussions

Formula Columns not working in the Alias table

Maran_Rengasamy — Wed, 29 May 2024 13:45:38 GMT

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

Re: Formula Columns not working in the Alias table

RADSr — Wed, 29 May 2024 14:38:36 GMT

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!

Re: Formula Columns not working in the Alias table

Maran_Rengasamy — Wed, 29 May 2024 15:42:09 GMT

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.

Re: Formula Columns not working in the Alias table

RADSr — Wed, 29 May 2024 17:48:52 GMT

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.

Re: Formula Columns not working in the Alias table

Maran_Rengasamy — Thu, 30 May 2024 12:36:04 GMT

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.