Dashboard Prompt not working for logical SQL

Summary:

Hello,
I've developed a report using logical SQL by combining several modules, and it's functioning correctly. However, when I add a dashboard prompt, the data doesn't filter correctly when I make a selection. Although we used aliases to rename columns in the SQL query, applying these aliases in the dashboard prompt query to display results wasn't successful.
Additionally, I've tried creating prompts using standard Subject areas but encountered similar challenges. I also tried using a presentation variable, where I prompted for a variable named "filter1" instead of choosing the "is prompted" option. Then I created a dashboard prompt that prompts for that presentation variable, but this approach also failed to resolve the issue.