So did you got everything you were looking for? Maybe you can then close the thread? For now still This question is Not Answered.

Not really as ... Christian Berg wrote:You have:- Dashboard Group - Dashboard - Dashboard page - Dashboard subpageThat's it. And subpages were only introduced in 12.2.1.1 by the way. So between "Dashboard Group" and "Dashboard" you see that there isn't any group in between. Can you create your hierarchy in the web catalog?…

Does your prompt use the same column? The smaller scope of a dashboard prompt is the page itself, so if your 3 dashboard uses the same columns you must make these 3 columns different (OBIEE works on the formula representing the value of the prompt when column based, when variable prompts just uses 3 different variables).

Hi Venkat, Did you read the README.md ? They tell you exactly how to install (so what to download). Making a long story short: https://github.com/d3/d3/releases/tag/v4.3.0 (current release) and you find the link to d3.zip and there inside you can't really miss the file. To deploy D3 on your OBIEE 12c you have 2 options: A)…

Hi, That's actually the default behaviour when using a pivot view and setting the "Data Viewing" as "Fixed headers with scrolling content". I just did it on a SampleApp 506 running 11.1.1.9 and it's what happened. Now when you say : We cannot use a pivot view here and needs a solution for a normal table view. Well ... You…

Please avoid double posting OBIEE 11g - Download All/Display All of rows in Excel Now there are 2 threads will probably stay unfollowed and open forever ...

Well ... still no idea why your bitools/bin folder is so "empty" .... Did you try to search the migration-tool.sh in all the subfolders of your OBIEE install folder? There is maybe a copy around (the original one the config copy and deploy in the bitools/bin folder). PS: with 12c no need to run the RCU by hand, the config…

And you did all the steps? Because the migration-tool.sh is supposed to be there (as the doc says as well). Which version of 12c did you install? And you installed 12c inside the SampleApp 406 ? (coming with a 11.1.1.7.1 by default)

Hi, Did your 12c install went fine? Because your /user_projects/domains/bi/bitools/bin/ folder is a bit "empty" compared to a normal install ....

Actually an absolute path is easier for debugging and maintaining the catalog "from outside". Using relative paths would be easier at a first look if objects (analysis, prompts etc.) are inside the dashboard folder, but if outside when having to deal with ../ etc. is easily a nightmare ... And the relative path would make…

To extend what @Joel Acha posted (which is correct) it's not about a process it's just how the tool works. Object embedded into a dashboard are referenced by an absolute path and not a relative one based on the dashboard itself. So your analysis added to a dashboard will be referenced by it's position from the root of the…

Hi Dilek, dileraco wrote:I know that each attribute column should correspond to one dimension table. I disagree with this one ... Fact table must contains only measures, attributes must go into dimensions but I wouldn't really say that each column is supposed to be a dimension. You can also have a kind of generic dimension…

Hi, Well, of course they can co-exists as they don't share anything ... So they will just not be aware one of the other I don't think Oracle has recommendations on that as they don't interact the 2 products (so it's all about your server: if it has 4Gb RAM just forget but if it's a real server with enough resources based…

Hi, did you try by WLST ? I already saw cases where the EM gui wasn't working anymore but by command line using WLST worked without problems. You go to your FMW home, then run ./Oracle_BI1/common/bin/wlst.sh (really take this one because there are 1-2 others which aren't going to work). When it open enter:…

Another example: you have a fact table that only exist at the Company level. If you don't add the other columns to the "Offices company" level in the hierarchies but want to use them in an analysis with data from the fact table existing only at the company level you will get an error first. If then you set the content…

You can display as many as you want. The "default" display column when using the "hierarchy" object in a report only show one, but all the others are still there. And when you use in an analysis these other columns and then maybe mix aggregations levels etc. OBIEE knows that these columns are at that level, so doing a…

Are you saying in your fact tables you have attributes without aggregation rule on them? Well ... of course that can't work. A text isn't a measure and has nothing to do in a fact table. Look at degenerated dimensions, it's how to correctly model attributes coming from the physical table being the source for a fact table.

Hi, The idea isn't to have only one column per level but more to put all the columns in the right level. So for the "Offices Company" level what columns do you have at that level of the hierarchy? Company and Company Key. If you had a "Company long name", "Company address", "Company attribute" they would also all go there…

Are yours physical servers? vm? network disk? (DAS/NAS) Honestly disk doesn't cost a lot nowadays and so I guess you can easily give it a bit more (50-75) if you can, knowing it will not be used but at least it's available. Mainly if you start updating to new versions installing them next to each other it will increase…

And https://docs.oracle.com/middleware/1221/core/BIEIG/GUID-E6545BC6-D0BF-4521-B3E7-160ABBBB6CD3.htm#ASINS325 (which actually point also on the previous link)