In fact, looking at the bit I can see in your screen shot, I would think that you need to change the $P!(dwhDBSchema) bit (highlighted in red on line 14 in the screen shot) - this is presumably trying to pass into the query a parameter (dwhDBSchema) which would contain the schema owner of the DWH and presumably that parameter syntax doesn't work the same in Jaspersoft?
If you are just "playing", then just replace (hardcode) that highlighted text everywhere in the query with your real DWH schema owner name (or just remove it if you are attached to that schema already).