Hi,
I'm building a report with a cascading prompt where the user selects a year out of a dropdown. This will autosubmit on a tree prompt showing the date hierarchy starting from year > semester > quarter > month. However, when I click on the + next to the month I get this error:
RQP-DEF-0311
The generated query does not reference any database table columns. Calculations and filters should reference at least one data column so that a legal query can be generated.
It's done on DMR package and the prompts both use there own query. The dropdown query uses an item with this expression: [Namespace].[Date (Month)].[Date (Month)].[Year]. The query for the tree prompt contains an item with the same expression. Has anyone ever encountered the same problem or does anyone know how to solve this?
Thanks in advance.
Hi,
I just tried this using the Great Outdoors Sales en powercube sample package. I managed to get it to work ok.
I created a basic report with a slicer filter - the slicer member set had the expression [Year hierarchy] -> ?TreePromptParam?
I added a tree prompt to a prompt page, based on the existing ?TreePromptParam? parameter, retrieving the hierarchy as the only item in the prompt query.
I then modified the expression of this item in the prompt query to be [Year hierarchy] -> ?YearParam?
I added a value prompt to the prompt page, based on the existing ?YearParam? parameter, retrieving the Year level of the hierarchy as the only item.
I set the value prompt properties to be Multi-select = No, Select UI - Drop down list, Auto Submit = Yes, Default Selections = the MUN of the year I wanted to select as a default
Seemed to work OK for me.
I have attached the report spec if it helps?
Cheers!
MF.
Hi MF,
thanks for solving my problem :) I just tried it and it worked. Is this maybe a problem specific for DMR packages?
Anyhow thanks again :)
RandomHunter