Technical Articles
Say Good-Bye to 60 Character Fun and Super Short Texts
Hello BW Friends,
with a sad eye we are saying “good-bye”, “adiós”, and “auf wiedersehen” to the 60 character limitation for characteristic values and long textual descriptions that were shorter than a tweet! 🙁 It was so much fun to find the workarounds and code one enhancement after the other. NOT!!!! 😉
Just check my old blog for the work the community put into this.
What’s new?
We are starting 2014 with a bang and have released SAP NetWeaver BW 7.4 to the market. You might have seen it in the roadmap update already but if not, here’s the BIG NEWS: You can create characteristics with a length of up to 250 characters and the textual description for characteristic values can now be up to 1,333 characters long. Woohoo, that’s more than enough to store my resume. 😀
What do you need to know?
First here’s the proof in the online documentation for Creating InfoObjects:
Tab Page: General – Modeling – SAP Library
Tab Page: Master Data/Texts – Modeling – SAP Library
Secondly, the change comes at a little price: You will have to check you custom code if it’s compatible with the changes and you might have to make some adjustments. Please see the following SAP Notes to prepare your system for the upgrade.
1823174 – BW7.40 Changes and customer-specific programs
1879618 – Pre-upgrade measures for upgrade/update to 7.4
What’s next?
We are working on tools to support you in the transition. Please stay tune and I will post updates here when they become available.
Also please post you experiences with the enhanced modeling options here in the comments.
Have Fun!
PS: Too many smilies? 😛
Best,
Marc Bernard
@marcfbe
our things simplifying using data length It's good.
Thanks,
Phani.
Thanks for sharing, it seems sap has give the option to store huge values .
This is an amazing feature given by SAP 🙂 . This would reduce stress on database level by avoiding codes and makes life very easy. Kudos to SAP team. 🙂 🙂
Much awaited feature has been finally released..Really elated to know that..Hats off to SAP team for getting this done.. 🙂
GREAT!!!!!!
Thanks a lot for this News!
Really excited to say good-bye to 60 character. 🙂
May I know whether this feature will be made available in BI 7.0 and BW 7.3 as well.
--KRPK
Hi Pavan,
No,This features is part of BW 7.4 version ...
Regards
KP
its great future and more needed one. Thanks Marc for sharing with us.
2014 started with a bang.
Thanks for sharing the info ..
Regards
KP
These are good news, one BW limitation less. Still too many limitations to improve tough!
any chance it will be included in further support stacks on 7.3x releases?
Zero chance. This is only available with BW 7.4 (or higher).
Regards,
Marc
SAP Customer Solution Adoption (CSA)
Now we can make use of this feature for all the comments related part. Thanks to SAP team. 🙂 🙂 🙂 🙂 🙂
Regards,
Krishna Chaitanya.
hi marc
great to know that character length limitation of 60 is now removed in sap 7.4 version and will really help in data modeling
Thanks Mark for sharing the great news for something that's been long awaited for. Is this feature enabled because of BW on HANA or HANA is not relevant?
Ali,
the feature is not tied to SAP HANA and available for all platforms supported by BW 7.4.
Regards,
Marc
SAP Customer Solution Adoption (CSA)
Hi Marc,
i don'T get the two ties together. First you say long texts available only in BW 7.4x.
BW 7.4x is for me BW 7.3x but optimized for HANA. Now you say this feature is not bound to HANA, but available for all plattforms (which I mean is really great). So can we expect a OSS Note / correction for BW 7.3x somewhen so that really long texts will work in BW 7.3x also?
Regards,
Jürgen
Hello Juergen,
sorry for the confusion (I edited my response). This is only available for BW 7.4 but for all databases and operating systems.
Regards,
Marc
SAP Customer Solution Adoption (CSA)
Thanks for updating Great News and New updates.
Hi Marc,
Thanks a lot for sharing the information. It is indeed a great news.
We are planning to take the info from STXH and STXL into BW. Now that should be fine with the new approach!!!
Thanks and Regards,
Jerry Jerome
SAP BW Consultant
Great things to know.Great work by SAP Teams. 🙂 .
Hi Marc,
Currently we are using BW730 Can u please give some idea about the OOS Note :
1823174 - BW 7.4 changes and customer-specific programs. I know this note applicable for BW740.
Just I want to know why we need to implement the OSS note and When we need to implement ?
Thanks,
Vimal Alexander
Hello Vimal,
If you do not adjust your custom tables and coding, there's a chance that things might not work correctly after the upgrade (activation or syntax errors, dumps, etc). There's also a chance that the upgrade itself will fail for example if you used domain RSCHAVL in the key of a database table.
The assessment of what actually needs to be adjusted should be done well in advance of the upgrade. Then you can put the adjustment work into the project plan.
In terms of timing, the changes are best done in the original system before you even start the project.
Regards,
Marc
SAP Strategic Customer Engagements (SCE)
Hi Marc,
Thanks a lot for such a wonderful explanation.
Thanks,
Vimal Alexander
Hi,
Its good to know that we can store char length to 250 & short Description upto 1,333 characters long.
But just want to confirm that will it affects to our performance of a report?
Regards,
Bansi
> Max length of up to 250 characters and the textual description for characteristic values can now be up to 1,333 characters long.
It's good news. SAP positioning SAP BW as EDW. In real life we have a cases when 250 chars is not enough. By example comments. Is there any plans at SAP to move forward and increase by example to 500 or more? Or any other options (maybe new characteristic type - Texts).
Wow, in BW 7.4.SP8
New with SAP BW 7.4 SP8: XXL - Attributes
Possibility to load and store different Files types (MIME Types)
as XXL-attribute into BW
• E.g. PDF’s, XML, Office Files, Images, Video-Files, Audio-Files
Store very long strings as attribute in SAP BW
• E.g. Twitter information (Tweets), File-paths, URL
Already started using 250 char master data.
Simplifies many tasks in BW.
Br, Harish
Hi All,
I have requirement to show a material description of more than 200 characters so I am using Extra Long text property for that material object in BW 7.5 on HANA and I have a BEx query. Here, I am consuming that BEx query in SAP Universe Design Tool(UTD) and using that Universe I have a WEBi report.
The reason that I am using Universe is, the WEBi report is very old one which was built on Universe. so, i have to follow that.
Here, issue is, even though i have set all the properties correctly in BW and BEx, my WEBi report is still showing 60 character length description in my WEBi report. I have become clue less after checking all the ways.
Can you please help me if i am missing something else that should be looked into really.
Thanks
Murali
Hello Murali,
I don't know if this is a functional gap, bug, or something not configured properly. Please create an incident report for BOBJ UTD so SAP support can take a look.
Best,
Marc
Product Management SAP HANA DW