cancel
Showing results for 
Search instead for 
Did you mean: 

could you please answer this questions. experts

Former Member
0 Kudos

what is the use of cell editor?

what are the sequence of operations carried out when transpoting object?

why we use navigational attributes ?please elaborate

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

hi,

what is the use of cell editor?

Refer this thread

what are the sequence of operations carried out when transpoting object?

goto transport conn--> select the objects from left to right hand side.. which u want to transport and slect collection mode i.e data flow before or after..etc

-give the request name

click on transport icon-->give the request name. and goto se10/se09 select that request and release it... finally goto stms tcode --> transport it from dev to qa or dev to prod..

why we use navigational attributes ?please elaborate

A navigational attribute is an attribute of one of your characteristics and it behaves like independent char and it allows drill down the report

thanks

Former Member
0 Kudos

hi..

navigational attrib:

From a system performance point of view, you should model an object on a characteristic rather than on a navigation attribute. The reasons for this are as follows:

· In the enhanced star schema of an InfoCube, navigation attributes lie one join further out than characteristics. This means that a query with a navigation attribute has to run an additional join (compared with a query with the same object as a characteristic) in order to arrive at the values. This is also true for ODS objects.

· For the same reason, in some situations, restrictions for particular values in the navigation attribute (values that have been defined in the query) are not taken into account by the database optimizer when run schedules are created. This can result in inefficient run schedules, particularly if the restrictions are very selective. In most cases, you can solve this problem by indexing the navigation attribute in the corresponding master data tables (see below.)

· If a navigation attribute is used in an aggregate, this aggregate has to be adjusted using a change run as soon as new values are loaded for the navigation attribute (when master data for the characteristic belonging to the navigation attribute is loaded.) This change run is usually one of the processes that are critical to the system performance of a production BW system. This is why, by avoiding using navigation attributes or not using navigation attributes in aggregates, you can improve the performance of this process. On the other hand, not using navigation attributes in aggregates can lead to poor query response times. The data modeler needs to find the right balance.

BEx Cell Editor: In queries with two structures, you can now reference cells at the intersections of rows and columns.

chk this link for transportation:

http://help.sap.com/saphelp_nw04/helpdata/en/0b/5ee7377a98c17fe10000009b38f842/content.htm

hope it helps..

all the best...

Former Member
0 Kudos

Hi

when you want to some calcuations in a particular column, you can use cell editor provided you use 2 structures

Navigation attributes are useful in finding the breakup of a result

You can use region as a navigation attribute for country sales revenue and see the breakup region wise

Regards

N Ganesh