Skip to Content

Query Design

Hi

i have one requirement where i have to put one constant value for all rows and columns but i don't want to put any info object in the cube for this constant evaluation in query. i have tried with structure but could not give the constant.

can you please suggest here.

regards

atul

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 29, 2011 at 05:30 PM

    Hi,

    What do you mean by "i have tried with structure " ?.You mean you tried to create the formula?If no then:

    To see the constant in rows, create a formula in columns and put your constant in it.

    I am not sure about whether you can do it for rows(i.e constants in columns),too.Nevertheless, try to create a formula in rows, too by right clicking the structure.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 29, 2011 at 05:37 PM

    Hi

    Can u explain ur reqirement clearly ? Do u want to keep the constant value at the columng that has to be created at the query level. If so then create the formula at the column . But i think u don't create the formula at the row level.

    Plz explain ur reqirement clearly if the above describe is not ur scenario.

    Thanx & Regards,

    RaviChandra

    Edited by: Ravichandra.bi on Dec 29, 2011 6:56 PM

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 30, 2011 at 06:46 AM

    Hi Atul,

    You will not be able to put the constant at row level. But you can create a CKF & put the required constant value & drag the same to columns.

    Regards,

    Pavan

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 30, 2011 at 03:29 PM

    Hi

    Can u tell me what infoobjects are present in ur rows i mean is it keyfigure or characteristic , if it is keyfigure then u create the 2 formula with constant value assigning to that . if in ur rows the characteristic are there then i mean u can't create constant values there.

    Plz explain scenario clearly.

    Thanx & Regards,

    RaviChandra

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      In this case, you can create one structure in row and create 2 formula. In each formula use formula variables and give default value to each of them.(provide default value, you can use replacement path)

      This way you can have constant value along rows.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.