user10473801 wrote:Currently, weblogic has no permissions (couldn't Edit) some folders in "Shared Folders". Also, some folders, he gets an error message whenever trying to access them:"access denied for user to path /shared/..."Could that be solved by checking the "Manage Privileges" page? Nope. Permissions are on every…

As Joel said there isn't a single source for that, the database can only give you the users / groups / role part if you ask nicely. Everything else (Catalog permissions) must be asked to OBIEE directly. As alternative to WLST you can also query the OPSS schema tables. It's less documented and require some "creativity" but…

Do you have the Essbase client installed and the paths configured? That was the cause in 11g, in 12c I don't remember (just because last time I loaded a cube was ages ago) if it's the same or it now goes via the javahost config on the server directly (but if that is the case I expect a message saying the javahost isn't set…

You have to check if your applications roles exist at the source: in Weblogic. There is where you can create / delete them, they aren't generated in the RPD, so you have to check in weblogic what's the status of your users, groups and application roles (and their members). Also check the "manage privileges" page in the…

The system-jazn file also doesn't really work in the same exact way in 12c, and I would avoid replacing it as you could run into more issues than you have. Start checking in Weblogic if your users and application roles are there. Are you really using the embedded LDAP as the only authentication? That one is more a dev…

Having a database object with the daily values will make your work in OBIEE easier as you can either change the joins and granularity of the current one or just add the new one as a new source for your current logical fact table. By telling OBIEE that this new database object can go down to the daily level OBIEE will…

The weekly split being always = 100 sounds like a percentage, so that you can take the weekly budget and make it a daily budget by applying the %. This is something which would work better at the ETL level: you don't have a fixed split anymore, you start with 2 special weeks but potentially you will have 52 exceptions or…

Hi, Those 2 issues you had are solved, right? That's my assumption based on the lack of question mark The name of the RPD doesn't matter anymore, in 12c the RPD itself works in a really different way than 11g, so don't pay attention to the file name but look at the content of things instead.

The first question is: what is your real target? Budget is at the week level, and now you seem have daily values with little to no link between the days and the week figures as nowhere has been said that the SUM of the daily split will be equal to the weekly figure you have. So what is the role of that "daily budget"…

The memory usage of the browser isn't directly linked to the size of the exported analysis. When you export the analysis the BI Server does the job and simply send a flow of data to the browser which save it on your disk directly: no rendering, no javascript. Displaying an OBIEE page, even more a 12c one, is tons of…

Turn off the auto-save setting or whatever it's called in your browser and make it prompt you to pick a filename and path where to save the file. At the moment you still couldn't prove that it's an OBIEE issue and not your browser not able to deal auto-magically with the file.

Isn't it just "normal" ? When you posted CURRENT_DATE = 05 November You get a 1 from the 21 November. 21 - 05 = 16 days, just a bit more than half a month. If the round 0.5000001 to the integer you get 1 from the 21 November.

3849347 wrote:BIEE12 is last version: 12.2.1.4.0 installed and patch (3 recommended patches).Java is:$java -versionjava version "1.7.0_80"Java(TM) SE Runtime Environment (build 1.7.0_80-b15)Java HotSpot(TM) 64-Bit Server VM (build 24.80-b11, mixed mode) I'm not going to read any further than this part of your post.…

Did you change the order of the columns, moving "product" to the left of "category" after adding the UNION ? This could maybe also explain things ... Still the thing is that your "Category" on screen isn't "Category Dimension"."Category" but the merge of 2 columns named like that. So the final name of that merged column…

Christian said everything already, but just to make it more explicit: your "custom calendar" can be an alternative hierarchy with a "normal calendar" you maybe already have. In the end calendars always tend to end at the same level (day most of the time). How those days are organized doesn't matter, OBIEE will be aware of…

When did they add Excel in "Data" thing? And when did they split it into 2 groups? I was still sure it was a flat list and the Excel 2013+ / PowerPoint 2013+ were the 'formatted' and CSV and tab delimited the 'data' (This clearly prove how often I do exports ) @Sishiho Makoto : you didn't mention what version, so you maybe…

Using UNION in analysis you prevent various things to work. Your column on which you click isn't "Category Dimension"."Category" anymore, it's a 'virtual' column which has been generated by the union of the 2 subqueries. I suspect that's the only reason why it stop working after you add the UNION. Navigation in OBIEE sends…

Hi If you export as CSV or tab delimited all the columns of the criteria of your analysis will be included. If you expert in Excel format it will be an export matching the view you saw on screen.

ForSly wrote:an aggregate fact table .... They are both at the same level of details. How is that even possible? An aggregated table, at least in OBIEE wording, is generally a fact table having less data by being at a less detailed level for one or many dimensions. Just like the other thread: you really have to post more…

Ah, that one. The checkboxes are into the dropdown list. You first have to enter a name for the key, once at least a letter is in the column "key name" on the next empty row, you can click on "Columns" and the dropdown icon appear and there you can open it and select the column(s) you need. The name generally comes…