Skip to Content

Removing unwanted text from the 'Webi_Properties' result field

Jun 27, 2017 at 06:38 AM


avatar image


I have a query while building report on CMS DB.

The BO server version is BI 4.2 SP3 P7.

Requirement - Create a report which will fetch BEx query details which is available in the system OR Create a report which will provide information of all reports in the system with the reports data source details

I have created a report with below details and it is fetching all the properties details in the webi_properties column

However; the column is bringing all other data such as <xml> DSID, DPNAME etc as well which needs to removed and only the data source names should be listed in the column.

Could anyone please help to find out only the DS/DP name and not all the details.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Best Answer
Narashimman K S
Jun 29, 2017 at 09:54 AM

Agree with all others here.

I had created this for DPNAME, you can edit to get whichever parameter you would like (also using just one variable or by keying formula in cell !)



=If([DP_NAME_START]<9;"Not Available";Substr([Webi_Properties];[DP_NAME_START];[DP_NAME_END]-1))
Show 2 Share
10 |10000 characters needed characters left characters exceeded

Thanks Narashimman.

Having one concerns, it only fetching 1st DS/DP name from the list, and we have multiple DS/DP name. I have tried with Loop condition but no success on this.

Could you please let me know how to fetch multiple DS/DP name from the list

Manikandan Elumalai Jun 27, 2017 at 02:04 PM

I dont think there is a direct way to get this as we dont have a individual object for the property which you are looking for. Instead you can create a variable at your report level and implement string processing logic to get the data which you require.



10 |10000 characters needed characters left characters exceeded
Koen Hesters Jun 28, 2017 at 01:21 PM

Hi via formula pos and substring you should be able to fetch the name out of it

10 |10000 characters needed characters left characters exceeded
Venkateswara Y Guptha
Jun 27, 2017 at 02:38 PM

Yes there is no direct way to query only DS/DP for all the WebI documents today. But I believe, this can be made as an enhancement for the BI on BI driver functionality, as in WebI the capabilities to find out DS/DP using the functions like =DataProvider(obj) / =UniverseName(dp) etc already exists. So, by combining the functionalities of both WebI and BI on BI driver by enhancing the existing functionality, in BI CMS System database sample universe this can be exposed as for each WebI document how data providers are there and what are those.

10 |10000 characters needed characters left characters exceeded