Hi,
Oracle, CR2008
I would like to set up a parameter "Week/Month" where it would prompt the user to select the value of either "Week" or "Month" and based on his selection, the report will return data from either the Week Fact Table or the Month Fact Table. There are no other tables involved.
I was attempting to do this with a command but not having much luck with it. the parameter within a command seems to be retricted to be used in the where clause.
Suggestions?
Oracle, CR2008
I would like to set up a parameter "Week/Month" where it would prompt the user to select the value of either "Week" or "Month" and based on his selection, the report will return data from either the Week Fact Table or the Month Fact Table. There are no other tables involved.
I was attempting to do this with a command but not having much luck with it. the parameter within a command seems to be retricted to be used in the where clause.
Suggestions?