Temoryian — Oracle Analytics

Welcome to the Oracle Analytics Community

Home› Temoryian› Comments
Default Avatar
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Temoryian Rank 4 - Community Specialist

Comments

  • 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…
    in Export Data in OAS/Data Visualizer Comment by Temoryian Sep 15, 2023 8:54PM
  • Thanks for your help! I'll file an SR and let the community know the results!
    in Export Data in OAS/Data Visualizer Comment by Temoryian Sep 14, 2023 1:18PM
  • 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!
    in Export Data in OAS/Data Visualizer Comment by Temoryian Sep 13, 2023 6:15PM
  • 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?
    in Export Data in OAS/Data Visualizer Comment by Temoryian Sep 13, 2023 3:59PM
  • 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…
    in Export Data in OAS/Data Visualizer Comment by Temoryian Sep 13, 2023 3:04PM
  • 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
    in Export Data in OAS/Data Visualizer Comment by Temoryian Sep 13, 2023 1:18PM
  • 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…
    in OAS Import/Export Bar Comment by Temoryian Aug 29, 2023 4:24PM
  • Thank you Gianni. I'll use the command line. Much appreciated.
    in OAS Import/Export Bar Comment by Temoryian Aug 8, 2023 3:08PM
  • 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…
    in Dashboard Folder Object/Folder View Comment by Temoryian Oct 25, 2019 11:14AM
  • 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:…
    in LISTAGG / LISTAGG Order In Answers Comment by Temoryian Oct 4, 2019 10:40AM
  • Sorry for being vague. Thank you Gianni your answers were very helpful and have put me down the right path.
    in Multiple Calculated Measures Comment by Temoryian Dec 27, 2018 12:42PM
  • 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.
    in Multiple Calculated Measures Comment by Temoryian Dec 27, 2018 11:13AM
  • 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…
    in Multiple Calculated Measures Comment by Temoryian Dec 27, 2018 11:02AM
  • 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.
    in OBIEE Analysis SQL Statement Comment by Temoryian Dec 21, 2018 1:08PM
  • 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…
    in OBIEE Calculated Items Comment by Temoryian Sep 7, 2018 4:40PM
  • Hi Christian, Thank you for your reply. I've been trying to get everyone to look at a different solution. So far no luck. 
    in OBIEE Calculated Items Comment by Temoryian Sep 7, 2018 9:30AM
  • 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…
    in OBIEE Calculated Items Comment by Temoryian Sep 7, 2018 9:29AM
  • 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.
    in Exporting Analysis with Multiple Views Comment by Temoryian Apr 27, 2018 9:07AM