Thank you very much , i also thought of it but I wasnt sure.

@joel I want to apply this in RPD as a part of security.

Yes i see the path, i am logged in as a admin user, it is weird I can create a new dashboard and save it on theat location , but when i try save as (some other dashboard) from some other location to Shared-->Components--> Dashboard it gives me this message.

Hi i did something simmilar, but this was great template, thank you very much!

This is the way to do it, thank you. But, is there any possibility to change it somwhere globally so i dont have to change it on every column in every analysis sperately?@Joel Acha Kr, Matija

Thx, for your reply, and yes this is related to the Drill through analysis from two fact tables . I managed to do what i needed, however it is quite difficult to explain my requirement here, but i really appreciate your contribution. Kr, Matija

P_GODINA = P_YEAR P_PRIKAZ_GODINA = P_REVERSE @Christian Berg

Hi, thank you for your effort. As i said ''Those two years are different columns one is for period and one is a business value.'' it is impossible from a business point of view that business value is greater than period so the scenarios you described will not happen. I managed to do it this way ( filtered column is…

Hi, sry for raising this as a topic, it was my mistake Disabled was ticked on my business model. Kr, Matija

I made a row level security and visibility of certain records in dimension tables with session variables, but this was a new thing for me. I appreciate your effort. Thx, Matija

Thank you very much Joel, i will go with this approach. Kr, Matija

Hi, thx for the effort, i tried but same message appeared, I used IE and firefox

That error is expected because it transfers from dashboar promt that is istored in variable P_GODINA and when it is populated analysis runs fine, it does not have anything to do with the import view disability.

Yes it is, why?

Make 2 connection pools and then create model for each, that can be your workaround, You will have two subject areas and you can work like that.

Nothing helped... thx for effort but none of this works, il raise SR for this because i cannot belive nothing helps..

Still the same ... I am out of options... any advice would be appreciated

I restarted BI components, i will now restart the server and let you know the result.. thx anyway...

@Robert Angel This column does not have any other column set as a sort order... so in my opinion sort should go alphabetically when i set ''sort ascending'' in OBIEE. Does database itself has to be set to a croatian , or I can override it somehow through OBIEE??

I dont know if i understood it right, i put croatian in Features tab in Admin Tool, changed LOCALE = "croatian"; SORT_ORDER_LOCALE = "croatian"; SORT_TYPE = "binary"; in NQSConfig.ini file and saved it then restarted BI components and nothing changed... stil english sort.. Did I miss something??