on 10-07-2008 6:40 PM
Hi All,
I have a situvation where i have a field in my flat file where the data length exceeds 60 characters and can go upto 800 characters. How do i hndle that situvation in BW. Please advise.
Thanks
Rashmi.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
The approaches you have mentioned esentially talks about dividing the texts into different info objects and then concaetenating them at the run time. This can be done when u know the length of a fixed finite value. In my case it is not, today the maximum is 1000 and tomorrow it can exceed that. Hence i cannot take this approach. Any alternative ideas.
Thanks
Rashmi
Check this blog :
In your case to make the length dynamic at infoobject level I dont think so its possible.Infact the method in the above blog is a workaround.
What I would suggest it as of now maintain as many attributes as required now.Later when that situation as you told occurs you may add one more info object and so on.
Since it will be just master data loading and enabling display attributes in queries it should not be a huge task.
Hope this helps.
Hi
If you can do some VBA programming you can join this long text from 3 different
infoobjects into a single cell in VBA. there was some post where they explained
about how they implemented it.
and one more option if you are using web reports then you can do this.
The procedure would be simmilar to the one which hides the fields in a table which
is explained in a how to guide
If the field contains more than 60 chars, load should not fail. It will simply
take first 60 chars. If your load is failing, there could be some other reason.
Please check the log, some common problems while loading through file are special
characters and alpha conversion erros.
Hope it helps
gaurav
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.