Palo Community Forum

is that problem with the newer Version now possible or is there another solution to get a timerange?

for example i have a dynarange in my report and want a preselection of date "Timefilter" (From 01.05.2011 - To 15.07.2012)

i checked the manuals, but found nothing about

thx for find a possible way

best regards
Marcus

Hi, I had a similar problem and solved it, but not very elegant. But: My solution concerns a palo.data-Rule, not a subset filtering like your problem. I would think you will find a better solution on the subset editors Data-part (using >= or <= combined with a variable you could fill via combobox.

Here the post of the solution for the palo.data: http://www.jedox.com/community/palo-foru…ight=#post14280

Best regards,
Stefan

Quoted from "ethssn"

I would think you will find a better solution on the subset editors Data-part (using >= or <= combined with a variable you could fill via combobox.

That was, i tried the hole morning, but every try with report preview ...
1. i wait more than 7 minutes to view something in the report and after or within that
2. the server had an error and we have to restart the hole server

What i´ve did:
1. i made two Comboboxes on a empty Excelsheet, where you can choose the Date from - to (only availaible Dates in the Cube/Dimension)
2. i took a dynarange in the excelsheet and select the subset, (Database/Dimension)-> "Test/date" sort them by basicelements and
3. on tab "Data" i select the two Variables in "Kriterium" - "from_Date >=date" & "to_Date<=date" and hope, that´s all, but nothing works

For my understanding is this possible to do with subsets, but can´t imagine why it don´t work. Dateformat is the same like in the Comboboxes.

Want to have a clear solution and no work-around. Have anybody another solution or path to success?

Thx a lot

Are there in cube dimensions: year, month?
Or one dimension only for date (name format of elements mm.yyyy)?

i want to made it "only" over date (yyyy.mm.dd), the dimension for year and month i don´t have or need in the moment and it´s not planed for other reports or something

thx if anybody brings me a step closer

Try this
1. palo.eindex give you num1 of element (combobox From value). Palo.eindex put in currrent sheet cell
2. palo.eindex give you num2 of element (combobox To value). Palo.eindex put in currrent sheet cell
3. Create cube (Vector) with 1 dimension (date) and 1 rule. Let something like Value1=palo.eindex...
So, result of cube cell is position element date in dimesion.
4. Dynarange based on subset on cube Vector. condition value1>num1 and value1<num2.

thx a lot sql8,
this can work. I will try it today