Hi Saurabh, Have a look at this: https://www.kaggle.com/datasets/mallikarjunht/all-india-pincode

Hi @User_57VNX , In addition to the options suggested by @Christian Berg-0racle , you can also export your metadata (catalog content, RPD, application role definitions and mappings) as a BAR file using the exportServiceInstance WLST command:…

Hi @DENISKA80 , As @Christian Berg-0racle already pointed out you have to enable the BI Server cache to achieve your goal. You have to edit the NQSConfig.INI file under DOMAIN_HOME/config/fmwconfig/biconfig/OBIS and set ENABLE = YES; under the [CACHE] section. You also have to make sure to mark your tables in the RPD as…

@user7618495 are you already running the configuration assistant as an administrator?

@user7618495 2012, 2012 R2 and 2016 versions of Microsoft Windows are certified and expected to work.

Hi @user7618495 , OBIEE 12c is not expected to work on Microsoft Windows Server 2019 as it's not listed in the certification matrix.

Hi @User_N8GVJ , You can calculate Total Credit Line as follows in OBIEE (of course you need to replace the names in the expression according to your subject area): SUM("Balance" BY "Customer Number")

Hi @User_PSZ9Q , Did you test the proposed solution to keep everything in a single analysis? Does it work as expected?

Hi @Marcus M. Thompson , Replace the filter as follows in your logical SQL and it should work as expected: "Customer"."Name" in (@{MyCust}['@']{"Customer"."Name"}) You have to use the column that you want to filter itself as the default value instead of % . In this way, you will get "Customer"."Name" = "Customer"."Name"…

@User_PSZ9Q you can do it with a single analysis by creating SQL filters to filter product codes and customers. For instance: "Product"."Product Code" IN (SELECT "Product"."Product Code" FROM "Subject Area" WHERE RANK("Measures"."Sales") <= 30) and "Customer"."Customer" IN (SELECT "Customer"."Customer" FROM "Subject Area"…

Hi @User_PSZ9Q , I would proceed as follow: * Create an analysis to get the top 30 product codes by Sales (Analysis 1) * Create a second analysis to get the top 5 customers by Sales (Analysis 2) * Create a third analysis and add a filter for Product Code based on Analysis 1, and a filter on Customer based on Analysis 2.…

Hi @User_OZYJB , Replace the default SQL as follows and it should work as expected: select DISTINCT YEAR(CURRENT_DATE) from XSA('MyLogin@somewhere.com'.'DATASET NAME')

Hi @user10408922 , If your LDAP supports user names with apostrophes (and blank spaces as I can see from your example) and the related security provider has already been configured in OBIEE, I suggest you to double-check that OBIEE is actually able to retrieve the user names from LDAP. In WebLogic Console, you have to…

Hi @Viswanath Kadiyala-Oracle , The syntax looks correct. Please note that the SUM function in your expression will generate a grand total and the value will be the same for all rows in your result set. Without having your data model/subject area on hand and knowing how you created the calculated measure it's a bit tricky…

Hi @User_27DEY , OBIEE/OAS currently does not provide this information out-of-the-box. Since information about recipients are stored in Agent objects in the catalog (in XML format), I suggest you to take an offline copy of the catalog and write a Python script to scan Agent objects and extract information about recipients…

Hi @Joe_obieeoas , I would check whether logical and physical SQL are the same on both environments. I suspect they are not the same, but once we know the difference it will be easier to find out a solution. Even if the analyses and the filters are the same, there could be small differences in the database features (RPD)…

Hi @User_SOJXT , If I understood correctly you would like to replace each comma in a string with ',' . To achieve this you can use the REPLACE function as follows (single quotes in a string must be escaped with one more single quote in front of them): REPLACE('290 ,21295323256434393972159779', ',', ''',''')

Hi @User_AD53Q , The column "Fact"."FTE" is an attribute and not a measure. You can clearly see this from the icon displayed next to it (which is blue and not yellow). You can either replace the current expression with something like SUM("Fact"."FTE"), or set up the default aggregation in the RPD directly. In both cases…

Hi @User_SOJXT , I'm glad that the solution I posted worked for you. You can mark it as correct in order to help other people with the same issue. For the new question, since it's not related to the original topic, I suggest you to create a new thread.

Hi @User_PHX1F , This issue usually happens when you apply an aggregation function (e.g. SUM in the example above) in the analysis to treat an attribute column as a measure: when you do this the filter will be ignored. You have to define the column that you want to filter as a measure directly in the RPD. If you do this,…