cancel
Showing results for 
Search instead for 
Did you mean: 

Warning message when i activate analytical view

09-25-2013 7:40 PM
896 views 11 comments Go to solution
0 Likes
SAP Managed Tags
Subscribe

Team

i have created a analytical view and i am getting the below warning message. request you to please check and suggest me accordingly.

0 Likes

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Likes

The names need to be in upper case.

BR,

Nidhi

Former Member
0 Likes

Hi nidhi

thanks for your help. now when i see the data preview the data is not there. further i went i checked that the fact table itself is not having data. so can you please suggest me how to get the data for that fact table.

fact table used is CE1IDEA table.

Regards

Raj

Answers (1)

Answers (1)

Ravi_Channe
Active Contributor
0 Likes

Hi,

These are warning, so you can ignore them. But please ensure that whenever you use these columns (defined in mixed / lower case) in any Query, Calculation, Formula , you should enclose them in double quotes  " " like "GrossRevenue".

Regards,

Ravi

Former Member
0 Likes

thanks ravi for your suggestion, can you please check on my other issue too.

Ravi_Channe
Active Contributor
0 Likes

First thing, you marked an incorrect answer as correct. It is not necessary that the field names should be in upper case. Please do not confuse other people who may have similar issue and might refer to this thread.

Secondly, please check your ETL. Check if your ETL jobs are running fine to load the data to the table. It could also be flat file data load, which may want to run to load the data.

Ravi

Former Member
0 Likes

Agreed. The warning is because of the mixed case letters. But, it does not mean that one has to use upper case letters. My apologies for not being clear.

Nidhi

Ravi_Channe
Active Contributor
0 Likes

Nope. not necessary. If you look into any XS application development, you will find that most of the development is in mixed case. It is just that it makes it mandatory to enclose the column names in double quotes.

Regards,

Ravi

Former Member
0 Likes

Oh, I see. Thanks for clearing that out!

Nidhi

Former Member
0 Likes

Hello Ravi

Apologies for the my mistake answer selection. Since i am new to HANA, i tried with UPPERCASE and then solved my issue. so i selected as correct answer. I dont want to make any confusion to other people who looks at this thread. so can you please suggest me, what should i do now to correct myself.

I am really happy to say that my first question in HANA is answered by you and you are guiding me on all aspects.

Really appreciate your help.

Regards

Raj

Ravi_Channe
Active Contributor
0 Likes

, no worries. Just wanted to make sure that everyone understands that even mixed case column names are possible.

It is always a good practice to keep column names in upper case.

End of the day, if things work, then no issues at all.

Enjoy working with HANA.

Regards,

Ravi

Former Member
0 Likes

Thank you very much for your encouragement ravi..