'.' is a column name basically and column formula is like below CASE WHEN "Time"."Month Num" =@{monthnum}{201905} then 105000000 END 105000000 will change for each '.' column as i'm showing multiple indicators vertically. I'm able to remove dot from column name but not the symbol.

Its Oracle Analytics Cloud 105.1.0-217, i believe front end reports/RPD are OBIEE even if we are in OAC so tagged both. if this not the correct way of tagging i can remove it off. regarding inputs, i'll take up my words. Sorry! its just a static number using the presentation variable i was able to move the pointer to the…

Robert, I forgot to mention. The same setup(mail settings) is working fine in another OAC instance.

Is there a way to handle this, because my result set will vary if i remove this column from the criteria / exclude section.

nothing wrong with the downloads, my downloaded files are here After exporting the first file using 7zip, below gets created

7Zip

Was trying to install Oracle BIEE 12c SampleApp v607 V While importing .ova file getting this error Could not create the imported medium 'C:\Users\hmungaru\VirtualBox VMs\SampleAppv607p-appliance\SampleAppv607p-appliance-disk1.vmdk'. VMDK: Compressed image is corrupted…

Yeah i have made those entries post installation. This resolved node manager and bi_server start up issue

Done!

Ok Thank you!

Hi Christian, This options are applicable at report level alone, that's what i was trying to say in my above issue. You can see the difference in the screenshots. Option are available when i stick to report and same option will goes off when i place the same report in dashboard. Thanks, Helan

Issue is with cache in the server. Added a new column in the report and excluded it from the results view and saved the report. Report is working fine now. Thanks

Yes you are correct when I try to load more records, error appears. So the left solution is Thomas's one ?

This is not possible I can't educate user's to do all these steps

Thanks much for your inputs, i never seen this logic till now MONTH_WID MOD 100. Very helpful !! I do agree with the Pivot view, but user has 12 columns in the source application and she is expecting same in OBI. they have used normalizer to convert it into rows in ETL. This might have some other purpose not sure. Apart…

Working now! Thank you

It has data, the same formula works when i write it in edit formula section

Will give a try. Thanks.

Yes both the syntax works. Its not a string but that can be handled using cast if required. There is no error, its just no data SQL looks sense [and D6.c3 = substr('2016R 3' , 1 , 4)]. Have tried LIKE too, same results - no data