column Value change in BO report vs HANA calculation view

[former_member245927]

Hi,

We are having BO  reports on  Standard hana views.

We have some columns  in calculation view as below in Hana studio

Column Name     Column Purpose

1.Cost Center---(Gives cost center number)

2.Cost center Name--(Gives description of cost center )

3.Cost Element-which --(Gives cost center number)

4.Cost Element Name-(Gives description of cost center)

when we preview the data with these coulumns in hana studio there are giving the result as specified above.

But if I run the report in BO using the above 4 columns ,I could see only descriptions for all the four columns as below

1.Cost Center---(Gives description of cost center)

2.Cost center Name--(Gives description of cost center )

3.Cost Element-which --(Gives description of cost center)

4.Cost Element Name-(Gives description of cost center)

As per our requirement we should get numbers for cost center and cost element.

I have observed in semantics that cost center and cost element have label columns mapped to them as below

cost center has labelcolumn as costcenter name

cost element has labelcolumn

Please see the attached file . Is this happend because of the labelcolumn mapping

we want the cost center and cost element to be displayed as numbers only.  Please suggest me on this.

Thanku

[former_member182302]

Hi Chandra,

TEXT is coming because you have defined as "Label Column" . In HANA, Data preview the column names will only come but not "Descriptions".

What is your reporting tool?  If it is AO, have a look on the below blog:

Regards,

Krishna Tangudu

[former_member245927]

Yes we are using Analysis office for Olap. So what do  you suggest on this?

[former_member182302]

Did you see the blog i mentioned? If you want to disable the texts, u can remove from the "label column" mapping

Or you can make it default i.e Key or Text or Key with Text from the settings i mentioned in the blog.

Have a look.

Regards,

Krishna Tangudu