I know, but this option makes that analysis works fine (load fine at first time and user no need to refresh). It's weird but it works. I suppose that If I recreate administration model could fix problem.

Thanks! But with 1024 pixels with screen resolution years and months are still overlaping, If I change resolution to 2000 it works, but not work for my costumer. Thanks for your option!

Thanks for your answers, Finally I could fix activate this option in answer analysis: With this option my analysis load perfectly. Thanks for your help!

Hello experts In that report....if I check this option: my report works fine (load at first time without any error) but it slow to load (20 seconds instead 1 sec) My customer woudn't approve it... This option is any clue to fix my issue? Thanks

Ok! Thanks I'll trace all of this and inform about results.

Ok, Now I know that issue is in admin layer but how can I havbe to fix? Aparently I have checked between prod and test exactly and I have same connections

It's weird because when I open report first time I have this issue, then I refresh and I see report perfectly (only If I click on refresh) If I recreate analysis I can see that are one columns that cause the error. That column I need to use to filter all analysis, when I create a filter for that column error appears. Then…

Hello @Gianni Ceresa Thanks for your reply. Is an analysis (answers analysis) and not contain any union This analysis is migrated from a test enviroment (In test enviroment works fine). If I create a new analysis from 0 with exact columns I obtain same error that I posted before.

Thanks for your replies. My requeriment is show all months and a year once. I know about Label orientation in X Axis. If I apply this option I see this: Month and Years are overlap and not work for my customer. Any help? I know about D3 tecnology but I can't setup javascript. I would like to fix using standard obiee…

Ok, Christian you are right. Thanks for your help Is anybody has any idea to get better performance in chart please help me. Thanks

Ok, @Christian Berg, I understand you. Anyway I don't understant behaviour of linebar and bar. linebar has data labes top of the bar. The other hand, bar chart has data labels inside. I thought to setup some xml to get this but I supose that is not possible...

Thanks for your help. Next time I'll add some snapshots for better understanding. I'll try my assignmenet and if I have any questions I will tell you about it. Regards

Ok, my steps are: 1st. Create two alias of my dimension: 2nd: In phisical layer join this tables to fact table: Origin Fact_table --> Code_NewOrigin Destiny Fact_table --> Code_NewDestiny 3rd: Drag two columns and Fact table to BMM 4th: Have to LTS in one table and rename table: Is all correct? Do I need anything else? Now…

Ok Gianni Ceresa and Robert, But if I create two different dimension tables user should select different columns to show results?

Thanks for your answers. @Christian Berg If I use fx editor i have same error when I add my formula. "CODI" Column is used more than once. Can you provide me some snapshot to create a complex join in physical layer. My problem is that I have two columns in my fact table that I want to join with one ID of a dimension table.…

haha Thanks!

Thanks @Christian Berg for your answers. I'll try about second LTS. By the way could you give an example about duplicate measure and create a CASE WHEN statement? Thanks!

Thank you for your answers! I'll try to install with Oracle Linux 7 when I had some time to learn! haha. Now I have a VM with Windows running. The problem was Loopback adapter. Now is working even if restart my machine. Thanks @Gianni Ceresa and @Christian Berg for your support.

Because I don't have knowledge to install a linux system... haha

Ok Thanks, I'm going to reinstall obiee and before I will install loopback adapter. Thanks for your help! I'll post my result.