Hi Tom, if I understand correctly you have to calculate a sort of an attribute "week", not filtered measures. With the filtered measures solution, you will not be able to obtain exaclty the same layout you show in your example. You say that "the values in these presentation variables can overlap, i.e., you can have "week1"…

Hi Steel, maybe you could use a specific db instruction in the xml of custom_messages, where you simply update the records using a where condition only on the "original" customer number (filed to add to the table and not to be overwritten) Something like update table set cust_num=@1 where ori_cust_num=@2 Regards Massimo

Hi, I think you should use the "use analysis" option in the recipients tab of the agent. Regards Massimo

Hi Matthias, one solution would be that of using the "Description Id Column" in the "logica column" but, as you said, you have not the possibility to change the datamodel. Another solution, could be that the analsys should have a filter like "Proj_id" and operator="is base no results of another analysis" And the second…

Hi, you should achieve this using RSUM funtion in your formula: RSUM(measure). Note: you should have in your criteria, only the measure and the "year month" detail, i you add other details and then you exclude this fields in the pivot, you'll get wrong data. Regards Massimo

Hi, I do not understand the reason of using the distinct. I suppose that you have to sum "Fact-Shanpshots"."AMOUNT" if your coditions are verified. You can achieve this, for example, directly in the formula of you analysis with something like filter("Fact-Shanpshots"."AMOUNT" using "Fact-Shanpshots"."DOC_TYPE" NOT IN…

Hi, I was trying to help, figuring out what he what was he trying to do, Without waiting for a formally perfect question. Eventually if rjak was looking for something other, he will ask again.

Hi, I think that the prompt should be a variable prompt. Then you should use the variable value to conditionally change the formula of a column in the criteria tab, something like: INDEXCOL( CASE '@{PVAR}{Daily}' WHEN '' THEN 0 WHEN 'Daily' THEN 1 WHEN 'Montly' THEN 2 END , '0', 'FILTER(MEASURE USING DATE=....)',…