I have integrated essbase and obiee. In report,i want to make use of 'variable' which gives me current year. For that i have tried making use of subsituion variable in essbase into report but was not able to do it. How do i accomplish this ? Is there any way i can query to essbase?
You could try create a repository variable with an init block. Set this to refresh everyday. that'll do the job. If you are using 11g, you need to create a separate connection pool inorder to create the init block(Though this can be worked around). Hope this helps.