I'm planning to have a look at Oracle JET also which i think is used by for VA visualizations. Looks like a pretty good tool to enhance answers analyses and I think with it you should be able to resolve the OP's requirement as well.

Did you use the quotes as suggested? : like '@{pWeekId}'

Late to the party because I was trying what Robert and Gianni already said and it works as described. Make sure tot put the reference between quotes for it to work, like '@{pVar}'. EDIT: I realize now your prompt is on weeknrs not dates, so the quotes might not be needed here, test it for yourself and you will know :-)

Not out-of-the box functionality in Answers. I think this VA does this, depending on the size of your slices.

TL;DR No, you will need to refresh the data yourself every time you upload a new file. Which is all explained in the Rittmanmead post BTW so please take some time to read that.

I do not have much knowledge on the subject of Cloud Services. Just wanted to share that adding data sources is a DV feature and not available through Obiee. Maybe this document will help you?: https://blogs.perficient.com/oracle/2017/10/13/how-to-connect-oracle-oac-to-planning-budgeting-cloud/

I do not know if VA is included in OTBI. The ability to access the Planning Database depends on what database you are talking about.

Be aware though you will need a Visual Analyzer license to use this option: https://support.oracle.com/epmos/faces/DocContentDisplay?_afrLoop=165801888133630&id=2093886.1

Did you check in the section permission that the user is not somehow denied access? (the last one is show in edit mode)

NIce one, thanks! :-)

You will not need any javascript for Roberts suggestion and I would follow it because it's easy and out of the box. If you must and have a lot of time on your hands you can probably do it with D3.js https://d3js.org/ https://www.rittmanmead.com/blog/2013/06/embedding-a-d3-visualisation-in-obiee/

Why are you using answers to make datadumps? The tool isn't meant to to that, It' meant to make analyses. Also what are you trying to achieve by making these dumps? There's probably a better way to achieve your goal then dumping very large amounts of data to csv/excel.

I have never had or seen issues with this no, I suggest that you follow Gianni's advise and raise an SR

That's what i meant yes

Did you check if outer join support is disabled for your Database? (It should be on by default)

Check out this post: https://www.rittmanmead.com/blog/2014/10/obiee-how-to-a-view-selector-for-your-dashboard/

If you are using a direct database query anyway (I assume that's what you mean by query written i sql) why not calculate yesterday trunc(sysdate -1) in the query itself? That being said, why are you using a Direct Sql Query? That should be used only as last resort. What you should really do is model this properly in the…

The solution Joel is suggesting should help. You don't need to calculate rank however, just order by total column in your analysis.

See: Welcome to OBIEE12c: Configuring External LDAP Authentication Part 2 - Red Stack Tech tl;dr : Remove the authenticated-role from BIConsumers

Did it work before? If so, what has changed? Check this note: https://support.oracle.com/knowledge/Enterprise%20Performance%20Management%20and%20Business%20Intelligence/1605206_1.html