yes unfortunately there is no LAST_DAY_OF_MONTH function, you have to go with -1 day from the following month to get the date for the preceeding month

I've not tried this before what is the format in the parent template, maybe the format specified there is overriding the format in the called template?

The first thought that I could think of was to have column with no right boarder that conditionally displays a $ based on whether there is a value or not rather than coding something in the numeric column

That is a bit strange so you are missing pipe separators? Could you show your definition as unclear what is happening

Here are some clear steps https://apexapps.oracle.com/pls/apex/r/dbpm/livelabs/run-workshop?p210_wid=3247&session=13634984880009

Looks like you're combining physical and logical SQL together not sure you're able to do a subselect in the way that you have structured it there. Can you detail the logic of what you're attempting to achieve?

Just to clarify you are storing the data to populate all 8 tables in the same row rather than 8 separate rows? Are you able to reorder the data so that the boxes flow as required as I'm not sure you can alter the functionality of a word column. Usually this is a repeated block based of rows of data.

Im not sure this is possible as not able to define in an rtf. I hope to be corrected

In the criteria tab of your analysis: Click the fact column and select "Column Properties" Click on "Data Format" Check "Override Default Data Format" box Specify decimal places and 1000s separator If you want this format to be applied to all the ocurrences of this fact column (and assuming you have the privileges) you can…

Could you provide the physical SQL from the query log please?

I found this similar post that cover off some ideas https://forums.oracle.com/ords/apexds/post/date-difference-between-2-dates-excluding-weekends-1201

The above would still include weekends in the count

Do you have a column in your date data for the academic year e.g. 23/24 you could then build your year hierarchy using this column rather than calendar year

This appears to be a known issue, here is another post with the issue that you have descrbed https://community.oracle.com/customerconnect/discussion/742734/move-dashboard-page-to-a-subpage

try these Mapping the QR Code in your RTF Template (oracle.com) https://youtu.be/oMIKpbOB1sk?feature=sharedhttps://youtu.be/oMIKpbOB1sk?feature=shared

It's been a while, trying to picture what you mean, in the past I've read the selections into a variable and combined using a filter

Is the CSV data coming in from a file or held in a database table field? Can use instr to search for the comma and substr to extract the data between located comma's. Is the data free text i.e. is it possible that the text contains commas as part of the text entry?

Do you have any matching dimensions between the two subject areas to enable them to connect

Have you looked at the Catalog Manager client? From a command line [DOMAIN_HOME]/bitools/bin/exportarchive.sh ssi <Bar file name>.bar encryptionpassword=<password>

Not quite understanding this, can't you read the YES/NO values into a prompt then use the value of the prompt in the data extraction SQL to filter the suppliers? You have multiple YES/NO prompts what is the purpose of each?