Yes , you can. You should focus hierarchies https://docs.oracle.com/middleware/12212/biee/BIEMG/GUID-3383503F-FBDA-4EB4-99B6-C2E7C3B5F24B.htm#create_manage_dim

"Solved the problem" Happy to hear that Solution is same that I said apart from OPTIMIZE_SEARCH. I think , problem is not about OPTIMIZE_SEARCH parameter and it is about "virtualize" parameter. Did you try without OPTIMIZE_SEARCH parameter ? NOTE : Also , set status to answered. Regards

Did you solve the problem ? If yes , how ? You should share the solution to help other that meet the problem like yours. Regards

Hi , * set DeafultAuthenticator's control flag to sufficient. * Login to enterprise manager (host:port/em) and add "virtualize" parameter with value "true" to Identity Store Configuration. * Restart OBIEE and test

+1 to Joel Acha , You have to check all RCU schemas such as [PREFIX].WLS , [PREFIX].BIPLATFORM etc.

Did you check Adminserver logs ? What is the error in Adminserver log file ? Please provide more details.

Hi , It's worth to check OBIEE 12.2.1.X Reports and Dashboards Using Dynamic Repository Variables Not Refreshing and Showing Incorrect Data (Doc ID 2338889.1)

I agree with you , dashboards should be built for data consumption and visual analysis However , that's the way to export all rows from dashboard export. If someone want this , has to follow these steps. Regards

Hi , edit dashboard and from "Tools" menu , go to "Print & Export Options" if you set "Print Rows" option to "All" , you can download all records from dashboard like table export.

Hi , there is a document about issue like yours. OBIEE version different but it's worth to check. OBIEE 12c: After Upgrade to 12.2.1.3, Business Intelligence Tab Is Missing In Enterprise Manager Fusion Middleware Control, bi-fmwc-discovery in Admin status (Doc ID 2309501.1)

I assumed that you are working in online mode. I don't think that is required to create on server , if you are working in offline mode.

Hi , Where did you create ODBC ? On OBI server or client ? If you created ODBC on client , please create ODBC on server that OBI installed and then try import metadata.

Hi DollyG , here is a scenerio that you can use. * create variable prompt * Create a report which filtered by presentation variable * Show the result

Hi DollyG , maybe you should give "Execute Direct Database Analysis" privilege to users/roles.

There was another thread in 11g. However , discussion is archived

Hi , * Stop opmn services (or you can stop only obis component)* If you are using OBIEE 11g , you can do it using "[INSTANCE_HOME]\bin"opmnctl.bat/sh" stopall. If you are using OBIEE 12c , you can do it using "[DOMAIN_HOME]\bitool\bin\stop.cmd/sh" -i obis1 * Backup NQSConfig.INI * set EVALUATE_SUPPORT_LEVEL = 2 * If it is…

Sorry for delay @Christian Berg, is there any document at MOS about how to recompile rpd ? I didn't find anything. @3310714 , Unfortunately sawserver.exe crashes periodically.

@Christian Berg , Basic answer Had a chronic crash problem in 12.2.1.2 and can't get solution from support for 4 months.That's why we decided to try 12.2.1.1 @FTisiot , I downgraded rpd from version 356 to 354 then uploaded to 12.2.1.1 but no luck. By the way , when I opened rpd in online mode after uploading version 354 ,…

Hi , my command was "obibvt.bat -compareresults Results\PrePatch Results\PostPatch -config testconfig.xml" and succesfully compared the results between environments. There is only one difference from your command that slash characters at the end of PostRelease\ and PreRelease\. As @3485869 said , remove slashes and then…

Hi , you can use other supported database that you can check from certification matrix. You don't need only oracle db. http://www.oracle.com/technetwork/middleware/ias/downloads/fusion-certification-100350.html Also you can find lots of information about installation from doc.…