Yes, probably you have to recreate the Action Links in the 12c environment because the migration to 12c might have overwritten the Report Links parameter in all the Action Links with default settings.

That BIAdministrator account seems to have the correct permission for the links to be visible. Did you follow the migration steps suggested by Oracle with the Migration tool and the other tools? Also, please check if you can add these missing Report Links to the reports that drill from the Action link.

Is there a column to identify the latest Unit Price? Any load date or some other sort of info? If so, simply include them into the report, create a rank measure on that column and hide the column. After this, just filter that column wihich equals to 1 showing just the Top record. It is as simple as that, if I have…

Did you log in with an Administrator user, such as the 'weblogic'? If yes, try logging into EM, after which click on Weblogic Domain -> Security -> Application Policies. Select OBI as the application stripe. Check if you have the BIAdministrator role assigned or not. Select [Resource Types] and investigate to see if the…

You must uninstall the product completely, delete the Oracle Home folder, Oracle entries from regeditor and try reinstalling it after a system restart. I hope that should resolve the issue. Even I have come across such an issue and was able to resolve it.

In such a situation where two dimensions are conflicting with each other, you must use both the dimensions together to be able to show the distribution of measure in a correct manner. If you include the Account column in Report 1, the data would be represented correctly. Logically speaking, if 2 different Reps make a sale…

Try reordering the views against the existing order, Table view on top of the Pivot or vice versa, whichever is applicable, and try downloading it into an excel file to see if the issue has been fixed. If not, kindly share the screenshot of the Results page of your analysis.

Try using Google Chrome if you are using IE. In case you are experiencing the issue in Chrome, try clearing the browser cache. Is the report a table view or a Pivot?

Ya,probably dropping this requirement and looking for an alternative would be the best workaround.

That would be too much for the requirement

That can be achieved easily had there been a single measure column. Have tried that already. What my limitation is, there are more than one measure columns in the report. Moreover, the requirement is such that it demands a combined report to meet the bare requirements of the analysis. So, any other workaround is…

So you mean to say there are no solution to this challenge?

If I create all the columns individually, I will not have any control over 'Quarter Period' since my quarter period is not fixed always, might be till Q4 for some and till Q20 for others. It gets filtered from a prompt created in the dashboard, as a result, creating individual columns might not suffice. I clearly want to…

Hi Sherry, The template is not uniform over other reports, I have edited the requirement and saved as a template. The report is basically required to be built in OBIEE.

But I suppose I will have a problem there, the most important thing I am concerned about. Adding columns would increase the no. of columns in Total after field as well, how do I control that? I do not have direct control over the Total columns individually. Also, I need to give a different name to all the Total columns as…

Hi Christian, So, do you want to say that the design needed for the requirement is quite impossible and is not achievable.

Hi, Very much agree with your reply, and so with the concept of pivot table in OBIEE. But, I do not want to show the extra columns under all the Quarter Period, that you have suggested to create. Basically, I need to skip two or more columns from the Quarter Period. Attaching a sample temple of what I am required to do.…

Hi, On which dimension are the stacks required to be displayed? If you need to show the composition of the stacks on the basis of the Brands, put Brand in the stacks and display the Brand name On Rollover option from Column properties rather than displaying it above the bars. The rest of the prompts seem fine. Also, change…

Hi, Check the level of data in which these figures are displayed. If you are expecting the number at a lower level, you need to group the data by that level. Define the "By level" at the end of the FILTER to achieve the desired result. OBIEE needs to understand the level of aggregation at which the FILTER is applied. What…

Hi, Use the Presentation variable to perform this task. Create the prompt for the FROM DATE prompt and set a Presentation variable (say PV_FRM_DT) for it. In the same prompt, create another date column prompt which should show values based on the FROM DATE presentation variable (using the sql query method to populate data…