The passing through is working correctly. But the xml that gets generated is the problem as its making the report not return any data

Thank you. It makes perfect sense

https://docs.oracle.com/middleware/1221/biee/BIESG/cluster.htm#BIESG9273

I think from an IT governance angle especially in corporate where systems are audited, even if that functionality could be implemented, it is such bad practice to allow OBIEE to be rearranging AD groups in MSAD. Your question sounds more like you require a system that you have control over in terms of creating groups etc…

Hi How it works is in MUD everything is based on projects. When you create an initialization Block or variable or a user or application role you still have to add it to the project for it to be part of the project. regards Emmanuel

Hi This might be slightly different but it could help with visualizing how to reference data in a specific row and use it in a calculation: Calculating % change from values in one column Regards Emmanuel

Hi Legends Thought I should just update you on this. With all the input you provided I decided to tackle it as below: To calculate the growth column, I duplicated the result column and filtered it by the minimum factor or lowest factor which as I mentioned is our starting point (Call it static result). I then summed it so…

Thank you all for the input. I am using an oracle DB so will try to LAG/LEAD. The blurring was only because of the data sensitivity but we could make sense of this using something else. The question is from a planning model where I need to know what the impact of changing certain percentages will impact the expected…

Hi Christian The formula is correct but my question is how can we do it so as to reference the growth from 155 to 210 in obiee. How can you use the contents of the position 155 like we would in excel i.e cell a1 for example. regards Emmanuel

Well Christian a single Iphone's downtime wont affect decision making. Apps on the that have smaller user bases are much easier to control. We have created a monster but creating a dependable platform. Now everyone cannot do without it.

I think @rmoff the legend has your answer on this one. Your logs or nework have an answer to this mystery of yours. Check the link below: https://www.rittmanmead.com/blog/2013/03/performance-and-obiee-summary-and-faq/ If you can also setup operational intelligence with something like Logly or Elasticsearch or sumologic, it…

Hi Unfortunately this is one of those you will have to deeply interrogate your logs. There are so many reasons why this could happen. Could be internal ldap locks or because you probably did multiple restarts one of the apps did not release the lock. If you are on linux try doing key word searches starting from warning,…

Hi I think this is what you are looking for: https://docs.oracle.com/cd/E21764_01/bi.1111/e10540/repositoryfinal.htm#BIEMG3445 regards

Hi By default in the catalog folder if an application role is not given the access then it wont have access. Read a bit on how the permissions work in the link below: https://docs.oracle.com/cd/E35225_01/doc.11/e29108/dash_reps.htm regards Emmanuel

Hi Shiva The codes and meanings are as follows: * N - No Access * R - Read * X - Execute (Also used to traverse) * W - Write * D - Delete * P Change Permissions * O - Set Ownership * L - Run BIP * S - Schedule Report * V - View Publisher * F - Full Control As per your report above the following users have the *…

This is different from a variable declaration where you will be reserving a space in memory. You only make use of the max records when you get to that value. In your case you have defaults that is why you are having problems. I am sure you have a dev server, play with the different metrics that way you will know the impact…

Go to catalog manager and select tools >> create report.

Hi You mention when you increase these values you have performance issues, that is something you have to tune and narrow down what exactly is causing the issue and I don't think its the instanceconfig.xml changes. From your response above I think what you are trying to do is set table properties for rows per page setting.…

Can you post the sql query?

The proof is in the SQL that obiee is generating. Have a look at the nqquery.log after running your analysis to see what obiee is generating based on your model. Its probably creating some cross join that is why you are seeing the multiplication of records. regards Emmanuel