Skip to Content
author's profile photo Former Member
Former Member

cell editor

Hi,

What is the cell editor?when do u use it?

why we need two structures to use cell editor?

can u give me a business scenario when exactly we use cell editor?

Thanks in advance

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 26, 2006 at 10:36 AM

    Hi pooja,

    First search the forum..you will find many entries..

    close this thread.

    regards,

    San!

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 26, 2006 at 10:44 AM

    Hi,

    you define queries for a combination of characteristics. Let's tell that you have query with design like this

    Rows:

    EmpID

    Columns:

    Emp Salary

    Emp Allowance.

    So tha data in the report is displayed like this

    Emp ID---Sal--


    Allowance

    10001---10000-----2000

    Now the data is displayed for all teh employee ID's.

    Well in the above case you have only one structure.

    So, the definition for a particular cell in not possibel. Which means the data for a particular empId cannot be defined for a particular cell. Where as if you use a structure you can always ensure in which cell teh adta for a particular EmpID is dispalyed. For this reason we need two structures.

    Extending the above scenario, supposing we have two structures.

    Rows(Structure)

    EmpID 1

    EmpID 2 and sso on

    Columns

    Salary

    Allowance.

    But for EmpId 2 We need to add special allowance in addition to regular allowance which is keyfigure in the cube. This should not be shown for others. But only for EmpId 2. The in the cell editor for that particular cell you can define a new formula which adds up the allowance and also the special allowance.

    The utput may be something like this before cell definition:

    Emp ID---Sal----Allowance

    1--


    10000---2000

    2--


    11000---2000

    The above allowance for Emp Id 2 does not have special allowance added but only regular allowance.

    After cell definition

    Emp ID---Sal----Allowance

    1--


    10000----2000

    2--


    11000----<b>4000</b>

    Here, the definition is given only for that particular cell which gets allowance for EMPID 2 only.

    Hope the above exmaple helps you.....

    Add a comment
    10|10000 characters needed characters exceeded

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.