Try Javascript

can you filter out a single record and see how long it executes. Also run dimension and fact separately and find the run time. Thanks Asim

CURRENT_TIME function is available in OBIEE. add it in the column formula and go to properties then choose custom as date format . keep HH:mm:ss as format and select Rangoon from time zone.

Try a substring where u use the valuee(presentation variable).

where are u using the timestamp. if it is in column or variables you can use sql_tsi_hour along with timestampadd function.

Hello, What is the total of records in your tables. Did you try taking the total count . Also after executing the report , Immediately navigate to manage sessions and check if the query actually running and sent to DB Thanks Aj

Check all your RPD initialization blocks

Show us the data u r getting in a table view and the formula used for day.

Ur requirement not seems to be very clear. Why cant you add the Month(date) column with >= 7 and Month(date)<= Month(CURRENT_DATE) ?

Thank you very much....

Thanks for the response. Can you please provide me the path in linux..

It worked... Thank you very much all of you.....

This is how it works when we extract it from command line. 1)When it starts extraction" Unexpected end of archive 2)CRC error

It looks like recognized though i am not sure..

Check sum matching and file names seems to be correct. Using 7 ZIP for extraction. File 1 : 3737BFD745D641DCF91C539581B8FB33 File 2 ; 1AC225F44E18B7AC8C98858430E3A790 File 3: D3C029DEE115B2458F0AE1A0DDC48FCB File 4: D5CAA8B65321F8E5A65A89E701CA92EA

dear saro, what is your requirement. did you try first filter then count? count(distinct (Filter ) Thanks Aj

Hello, Could you please elaborate by using join diagrams and RPD objects?

It would be great if you can close the thread as answered. Will help future users of this forum..

Thank you very much..

what is the results you are getting now in pivot?