Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
I have now fixed this. One thing I did notice is that the Prompt settings weren't Bold like other hardcoded filters when looking at reports' filter criteria. The formual I have used for fiscal period is (To default to last period): SELECT "Time"."Fiscal Period" FROM "Financials - GL Balance Sheet" WHERE "Time"."Fiscal…
-
Good idea, I've just tried this and the column populates with a number: "1201804300000" I've fixed this before in a test system as the Session Variable didn't work by using a SQL formula in the default prompt selection for: select DESCRIPTOR_IDOF("Time"."Fiscal Period") from "Time" where "Time"."Fiscal Period" =…