Well, not really. Had to reinstall everything.

@Thomas Dodds That is true in most cases, it is like 2 measures in a table. In this specific case, I was wondering if we can do this as my user really doesn't understand the limitations which I will anyhow address with him soon regarding this. Thanks for the message though.

Sorry @cesar.advincula.o, I think there is a slight confusion in what I said I needed. Your approaches work good for Grand Total but my final output from your example should look like this as shown below: Yours looks like this: Mine should look like below is what I meant. See, it is becoming cumulative at the end of 2012.…

@cesar.advincula.o True, but what formula would you apply in the column formula to make pivot table understand to pick up Grand Total as Cumulative Total. Can you please share an example with a screenshot? Appreciate your input.

Sorry correction to the table data: CustomerFiscal PeriodFiscal DateAmountAJan, 20161-Jan510-Jan215-Jan-6Total 1AFeb, 20162-Feb313-Feb1114-Feb-425-Feb-2Actual Total 8Cumulative Total 9

Thanks @Srini VEERAVALLI for the input. But it doesn't work in my case. For example: CustomerFiscal PeriodAmountAJan, 201652-6Total1AFeb, 2016311-4-2Actual Total8Cumulative Total9 I need the cumulative total. Like in the above example, I need the report to display Cumulative Total but not actual total. With the logic you…

Sorry it was the spaces that were causing the syntax issue. Thanks @Gianni Ceresa

Yes, absolutely. I have re-migrated the security just in case again successfully but in vain. The services dont come up. And the logs are still the same: [OracleBIClusterControllerComponent] [ERROR:1] [] [] [ecid: ] [tid: 10b8] [46137] CSF error encountered. Error code: 29106. [OracleBIClusterControllerComponent] [ERROR:1]…

@Christian Berg Thanks for the doc. This didn't help in my situation. Any other suggestions please?

@Gianni Ceresa Yes, I did see the community post earlier and installed Process Monitor on my end. The reason I had to pose this question was to know if there was an equivalent Windows command line option for the above command. But thanks for your input though. @rmoff Likewise we do in Linux, I wanted to troubleshoot each…

Oh sorry. I get it. Its just that the loging content increases. Do you want me to repost my logs after a reboot?

Yes, I have made changes as mentioned in slides 36 and 37. But, where can I find those log files specifically(paths)? Secondly, we use WLS LDAP.

Christian - Thanks a ton for the doc! Well, post setup, I see this error below. Any input is appreciated: Thanks.

@handat Just FYI, this is what my migratePolicyStore.wlst file contents look like:

@handat - These are the arguments that I have passed C:\Policy Migration> "C:\Middleware1\Oracle_BI1\common\bin\wlst.cmd" migratePolicyStore.wlst Ya, I am not sure of the string. The above arguments should help create a new system-jazn-data.xml file. Appreciate your thoughts. Thanks.

Thanks @Gianni Ceresa. I think it works. Let me test in higher environments with better data. I will close this as answered then if it works.

Dan - When I use your logic, I get an error because I don't have any measure columns in discussion: Function FILTER requires at least one measure column in its first argument. (HY000). Both the tables are dimension tables in same subject area. So, here's what I am trying to achieve: When "table1"."column1"='A' then I…

I guess I learnt it the hard way. Appreciate it.

Thanks Christian. But here's the problem, if I replace your URL with my column name, it doesn't work. Because my column contains data that are URL's. Please see below: '<a href="http://www.google.com" target="_blank">This is a URL</a>' with '<a href="Table Name"."Column Name" target="_blank">This is a URL</a>'

Gianni, Yes, it has been addressed couple of times but couldn't find the right solution. Hence, a request, 1. Do you want me to check "Contains HTML Markup" in Column Format? 2. If I don't have any HTML in my formula and go back to actual column formula, it works after setting HyperText as column's data format. But, when I…