The problem was that even though I had a BIServiceAdministrator role, BIConsumer was missing some permission sets that are needed to see the export options. I previously had to added permission sets to application role BIServiceAdministrator which are missing for out of place migrations from OBIEE to OAS. I navigated to…

Thanks for your help! I'll file an SR and let the community know the results!

Please see below application roles. I have these and two other custom roles: I'm the creator and owner of the workbook and dataset. Present mode right click on cell: Edit mode right click on cell: Thanks!

When I open a workbook (default presentation mode) and right click on the canvas, here is what I have for options: Any ideas what I don't see an export option?

I can't export a workbook into any format even though if I right click on the workbook, I see the export option: When I open the workbook and am under the Visualize tab (or preview tab), I don't show any options to export the data either: Sorry for not being more clear, but neither option are working. Can someone include a…

Thanks Steve! Could it be possible to have the OAS documentation be updated to reflect that? https://docs.oracle.com/en/middleware/bi/analytics-server/user-oas/export-visualizations-data-csv-file.html#GUID-D2E5F5E4-1BC7-4619-959C-303C5DF83C24

Just wanted to follow up in case anyone runs into the same problem(s) I have. Turns out that there is a bug for doing an out of place migration from OBIEE to OAS. The solution given encounters another error for windows users so you need to go into two scripts and change the delimiter from a comma to a colon. To solve: On…

Thank you Gianni. I'll use the command line. Much appreciated.

Hi Christian, Our organiziation was mimicing a previous folder structure from a previous product and made the decision to keep it to try and make things as familiar as possible for our end users. I've found this on https://gerardnico.com/dat/obiee/obips/dashboard: "If you save the dashboard in the Dashboards subfolder…

Hi Joel, Thank you for sharing. I had seen that thread and noticed that they wrapped the LISTAGG in an EVALUATE function. My organization has the EVALUATE_SUPPORT_LEVEL parameter in the NQSCONFIG.INI file turned off as mentioned here and unfortunately they won't turn it on:…

Sorry for being vague. Thank you Gianni your answers were very helpful and have put me down the right path.

Yes the formulas are conditions based on 2 dimensions. I am not displaying the dimensions that are used to obtain this value in the pivot table. What I'm trying to accomplish is to get all of this data into one record/line.

My apologies - yes this is an analysis/obi answer. Here is the logic one of the calculated measures. The logic for all three are basic case statements: CASE WHEN Table.Column = 'WPT' AND Table.Column = 'MFND' THEN Table.Column END I get ripped when I say this but I only have access to the presentation layer and hence why…

More clarification - My institution used Hyperion for reporting purposes. I'm trying to mimic queries/reports built in Hyperion as OBI analyses. Converting might have been the wrong word there but that is what I'm trying to accomplish.

Hi Guys, Thank goodness it is Friday afternoon. I have two separate issues here: 1. CONCAT strings by ID 2. SUM displayed values from CASE statement and place that value in new column so I can reference that number in another formula. In the first of two examples above (sorry if I wasn't clear enough about this) I need the…

Hi Christian, Thank you for your reply. I've been trying to get everyone to look at a different solution. So far no luck. 

Hi Robert, Thanks for your replies. I would love for our organization to pick a different solution but unfortunately I think we are stuck going down this path. I will continue to try to influence them in a different direction. As far as casting and then concatenating that would work for putting two ID's together but I'm…

Thank you Gianni. I have been using the CSV export because we have been receiving the Excel export error that we are in the process of fixing. I found a resolution to that error in the forums here: I will switch back to exporting to Excel.