Thanks for your answers, What do you mean when you talk about SVG? Thank you

Yes, you are right, the direct variable is shown the issue is when I want to apply an operation to that variable, do you know any way to do it? Thank´s in advanced.

Yes but in the headers I only see the html option but being able to show variables does not allow me, it takes them as plain text, does anyone know a way to do it? Thank you

Thanks but that does not work when we talk about selection steps, only when the rows are displayed naturally, and that's the problem

It is correct, but it was just as an example to show more clearly what I needed to explain, the idea is with any metric, to which I need to display with and without decimals per line, using the column selector.

Yes, you are right, thank you.

I already search in the query log, but I can´t find the alias, so the problem persist..=(

Hi Gianni do you have information about how to do this (amount by state) like the picture that you share with me, on the RPD? You said that I can use content level, where can I get information about that? Thanks a lot ESM

ok, thanks

Thanks for your answer Gianni, what do you mean with DV?

Hi Christian! Thanks for your answer, I just was hopping that for txt files to be different, since in windows they are different odbcs, but I appreciate the information.I have to think about how to solve the problem, thanks again. =)

Thanks #Mayur could you share a little more detail of your answer? Do you use the function on the rpd or on line? do you have any technical reference that you can share with me? Thanks a lot ESM

Hi Gianni! You are right, Maybe I didn´t express my doubt in the right way, I was trying to do than on the rpd, the image that you shared in an online example? I think it can be useful to me, Could you share the technical reference that support the example of the image please? Thanks a lot ESM

It is not a problem of modeling, it is as simple as wanting to place a calculated column like in the example that I showed in the post, if I put the sentence you suggest, it marks me a syntax error, it is not the first column that I calculate but I have problems with the cume and the colmax, in fact the syntax that you…

That syntax is not allowed in obiee 12c, you can´t use by

Thanks Angel but OBIEE 12c doesn´t aloud the syntax (by)

Thanks but OBIEE 12c doesn´t aloud that sintaxys: nQSError:27002 Cerca de <by>: error de sintaxis nQSError:26012 and that´s my problem..

The Cume function returns a cumulative running total for each value in a column of numbers. Cume (numbers, break_col) where: numbers references the column that contains the numbers on which the cume is calculated. break_col is a parameter that references a break column. Example: CUME (Amount, State) The results are shown…

Yes, I need the max by a breakcol; but I can´t use that sintaxis in OBIEE . In this case MAX(Amount by State) but OBIEE does not allow that sintaxis. Do you know another solution? Thanks