Dear reader,
Query filters have a lot of filters. However, is there a way to apply a query filter on Period/Month, to only choose the period prior to the current month?
For example: It's november right now, period = 11. Is there a way to make the...
Dear user,
For a header I'd like to combine the text of two cells (two dimension variables).
I tried =[Account]&[Account Descr], but this didn't work. Example of what I'd like:
Account: 4000, Account Description: Purchase. Then combine the two ...
Hi everyone,
This seems like a simple question, but I just couldn't figure it out..
I'd like to remove duplications, but just keep one and sum the values of all the duplicate names. Example:
I'd like to turn left to right: avoid duplicate...
Hi,
So I'm working with budgets and spendings, I'd like to add a column that shows the cumulative spendings for a GL account, I can't figure out how sadly.
The goal is to have month 2 the sum of month 1 and 2, month 3 to have the sum of month 1,...
Hi everyone,
So in my report I have two types of receivers, one from the main universe which is a dimension. Another receiver that's a result from a detail, so a different universe. They're seperated in the report and I'd like to combine them, I tr...
THANK YOU!Once again, you helped me out. Thank you so much sir!Got it to work. The date we're using is dd/MM/yyyy, so I changed it to substr 4,2.The query filter works perfectly!
Hi sir,I followed your steps, should I ignore this notification when I press Parse on the Month -1 dimension?Next up I encountered this problem: the Fiscal Period dimension is a character dimension and not a date dimension... It's a list of 01 tot 1...
Hi sir,Thank you again for helping, could you enlighten where to enter add_months(sysdate, -1)?I'm unfamiliar with creating variables in the Universe Design Tool...Which entries should be filled, and what should the entries contain?Kind regards!
I think it's a matter of creating a date dimension in the Universe Design Tool.I'm in the universe design tool right now, I think I'll have to make a dimension that's equal to sysdate - 1 month.I'm thinking sysdate ... add_months(-1,)?
Hi I figured this shortly after, only thing is it returned MultiValue. I have an input control where i only chose one account number. It still returns multivalue error...