Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Previous quarter value in variable
Answers
-
AND????
Are you sure the two are true in combination??
0 -
But can I repeat my question.
On a row of data are you certain that both parts of the AND statement can be true at the same time?
0 -
3612030 wrote:"Pipeline Snapshot Date"."Pipeline Snapshot Enterprise Quarter" IN (CASE WHEN RIGHT('@{QUARTER}', 1) = '1' THEN CAST(CAST(LEFT('@{QUARTER}', 4) AS INTEGER) -1 AS CHAR)||' '||'Q'||' '||'4' ELSE CAST(CAST(LEFT('@{QUARTER}', 4) AS INTEGER) AS CHAR)||' '||'Q'||' '||CAST(CAST(RIGHT('@{QUARTER}',1) AS INTEGER)-1 AS CHAR) ENDWhat in the name of everything holy, unholy and in between?! Why do things easy when they can be made complicated X-D
0 -
I don't see any single quotes that should enclose this character value in the SQL filter, in either of the versions you show. But that would throw an error, not "No Results".
0 -
Forcing the query engine to write bad/inefficient SQL to boot ...
0 -
Yep. Basically like pluggin in a microwave you modified into your car to override its engine management software.
0 -
On my last question, can you prove this for me; -
"But can I repeat my question.
On a row of data are you certain that both parts of the AND statement can be true at the same time?"
Create explicit filters that would create the equivalent of what you are trying to achieve with the date based filter - see if it gives you any data??
If not then look into using filter functionality to achieve your desired result, accessed via the function palette.
0 -
Robert - again didnt worked, still no results.
Christian, Thomas - I would really appreciate to get this "simple" solution since you already commented my case.
This SQL is issued that way because the column with Quarter IS NOT A DATE and even if casted to, the format would still be "2018 Q 2" and that still I CANNOT use to make a calculations! Remember, Im using prompt presentation variable and I have to pass this to second - Historical - Subject Area.
For example, using your suggestion about AGO function, this didnt work for me because of "Unresolved level" error - AGO("Historical Pipeline Facts"."Closed Opportunity Revenue", "@{QUARTER}", 1)
In fact everything that I include in this function throws me this error, no matter the column.
I would really appreciate a much simpler solution to this problem
0 -
And did you try my test with two explicit filters to ensure that the data in combination (in the same row) actually does exist?
0
