Dear SaiKK, Please make changes as per the below screenshot: You need to go to your analysis and select "Print & Export Options" --> Change "Print Rows" from "VISIBLE" to "ALL". This will export all the records in the email. Hope this helps. Please mark this as resolved if this helps.

Hello, Did you tried the format suggested? Was it helpful to you, please?

Dear User, Can you please check if you have a folder at below location: <Domain_Home>/bidata/service_instances/ssi Also, I presume, you have already moved the bidata folder to your NFS location (clustered node shared folder)

Dear User, If you are still having troubles, can you please post out put of SQL Query, including your columns "Pipeline Snapshot Enterprise Quarter" and "Enterprise Quarter". The condition will be to show valid record for any Quarter (I'm expecting output something similar to 2018 Q2 and 2018 Q3 respectively). The reason…

Dear User, Please try this: 1. Create another dashboard prompt 2. Write a SQL using your logic "CASE WHEN RIGHT('@{QUARTER}', 1) = '1' THEN CAST(CAST(LEFT('@{QUARTER}', 4) AS INTEGER) -1 AS CHAR)||' '||'Q'||' '||'4' ELSE CAST(CAST(LEFT('@{QUARTER}', 4) AS INTEGER) AS CHAR)||' '||'Q'||' '||CAST(CAST(RIGHT('@{QUARTER}',1) AS…

Hello User, can you please try using %% instead of % ....?

Dear GURUS, I was somehow able to resolve the issue, however, I am facing some other issue now as below: Exception: krb_error 0 Do not have keys of types listed in default_tkt_enctypes available; only have keys of following type: No error KrbException: Do not have keys of types listed in default_tkt_enctypes available ;…

Yes, just a little change. I'm having Windows 2012 R2 server, so the command becomes: kinit –k –t /app/bi/12_2_1_4/user_projects/domains/bi/cofsm042.keytab HTTP/cofsm042 I'm on OBIEE 12.2.1.4 and Java version is Java 8.131

Sorry for not getting it at the first time... I'm failing at step 4 of Part 2 "Test if the WebLogic Server is able to find the KDC Server and able to obtain a ticket or not:" I'm running the command manually by filling in the required parameters. The original command is : "kinit –k –t <keytab-file>…

Hello Christian, I have highlighted the command fired in RED and the error I am getting. Reposting: Command firing (errored out)---- java -Dsun.security.krb5.debug=true sun.security.krb5.internal.tools.Kinit –k –t <path_BI Domain>.keytab HTTP/<Principle_Name> Output------------ Java config name: null LSA: Found Ticket LSA:…

Hello Vyshak, You can create 2 Repository variables and assign them as default selection for the prompts. I think that should work.

Hello, Can you please check the OBIS log to see if it contains the error details as well? Please check other logs as well.

Hello, Did you tried to check the respective log files?

Hello, I am assuming you have all the data in your DB table (which is without SCD). Why cant you use <JOINED_AS> = "INTERN" (or whatever your "intern" is defined as) instead of using a "%intern%" on OBIEE Side? Do you have a fixed job title defined for Interns? If yes, you can use that directly with equate operator. Hope…

Hello, Your Table name from the initial screen shot is "Industry" But, from the new screenshot, you are referring to table "Primary Industry" As highlighted by Christian Berg, I think this is causing the problem. Have you renamed the table as well...?

Thanks a lot to both @Joel Acha and @handat.... The issue got resolved somehow... Following https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=100821038316758&id=2408448.1&displayIndex=1&_afrWindowMo… gave an idea that the location of tnsnames.ora has changed significantly in the latest OBIEE 12.2.1.4. When we…

Can you also share a screen of the Presentation layer (the alias) as well? As Robert highlighted, you do not have to do anything post creating a alias in Presentation Layer.

Hi, Can you please share the details, like the environment details, error screens, etc.?

I would just say that there are some people (with POWER) who doesn't understand or let's put it like, who doesn't know what they actually want.... And due to lack of proper requirement and understanding of the system, OBIEE is just used as another EXCEL, data downloader, etc., etc.,.... Yes, you can do a SEARCH and REPLACE…

What type of SSL have you configured in CONSOLE? Can you give some screenshots to better understand it?