Dear Gianni, Do you always need to set all the filters? >>Yes Gianni, as of now to see the data it is asking to set the filters or else it is resulting in No data. Don't you maybe just need to set some high level one and then having the column in the analysis is enough to explore your data? >> Our expectation is like that…

Hi Gianni, I need your suggestion for my query. As far as with the essbase result in BI im getting the results for the right combination of data in BI. Say for the result to appear i need to give the below no of filters in my analysis Suppose if i remove any one of the filters from the above, im getting No Results. Incase…

Thanks Gianni. With the right combination i can fetch the results. Regards, Saro

Dear Gianni, Thanks for the reply. I performed filtering of the particular dimension members to view the result of the measure. The below is the expected result for measure 1500 My analysis with the following filters The results are only if i compare the dimension attributes But if i apply any of the measures to the…

Thanks christian. Got it.

Hi friends, Got the reason, as this will be enabled only if both the SA are related to each other. Hence in my case 2 SA are from two different views and it is not related to each other interms of joins. Thanks, Saro

Guys, any idea about this problem. Regards, Saro

Thanks Thomas, for the reply. Will make a time dim to deal with my scenario:-) Regards, Saro

Hi Pedro, Thanks for the reply. I dont have any date column, as of now im displaying the default sysdate in it which i have created using variable prompt. In that case what can i do without a date column. Regards, Saro

Thanks Gianni, for the explanation:-)

Gianni, thanks ;-) But the thing is mainly, i do want to hide the column labels because i want to export that report to CSV format in which the column labels on is creating an unnecessary comma @ the top of the first row while exporting like below ,,<-----------------comma created due to headerTPT,4125TPT,27725 So i…

Dear Cesar, Thanks for the reply again. I do noticed that my employee number column is in varchar type and due to that it resulted in incorrect numbers it seems. After that i changed the formula to below to number format and it worked like expected. sum ("Airfare Adjustment-fact"."Result Value" by EVALUATE('to_number(%1)'…

Hi guys thanks for the reply. Indeed i tried with the below formula sum("Result Value" by "Employee Number") for one of the column Result value total and i get the below results If you can notice @ the above for 384 the Result value total need to be sum of Result value which is (2857.86+26116.93+2891.10+6366.90) = 38232.79…