cancel
Showing results for 
Search instead for 
Did you mean: 

Removing unwanted text from the 'Webi_Properties' result field

Former Member

Hi,

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.

Accepted Solutions (1)

Accepted Solutions (1)

former_member207052
Active Contributor

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 !)

DP_NAME_START
=Pos([Webi_Properties];"DPNAME")+8

DP_NAME_END
=Pos(Substr([Webi_Properties];[DP_name_Start];50);Char(34))

DP_NAME
=If([DP_NAME_START]<9;"Not Available";Substr([Webi_Properties];[DP_NAME_START];[DP_NAME_END]-1))
former_member182521
Active Contributor
0 Kudos

Perfect Narashimman K S

Former Member
0 Kudos

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

Answers (3)

Answers (3)

kohesco
Active Contributor
0 Kudos

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

VenkateswaraGY
Product and Topic Expert
Product and Topic Expert
0 Kudos

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.

former_member182521
Active Contributor
0 Kudos

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.

Thanks

Mani