Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Extract SAP BFC data through QBridge

Hello,

QBRidge is used to read SAP BFC: business objects Financial Consolidation tables for intra group transactions

Example of understanding: we want to compare the amounts of the following groupings of accounts 1 and 2

RGP1: Group 1

Account 11

Account 12

Account 13

RGP2: Group 2

Account 21

Account 22

Account 23

The problem when reading the table, to my knowledge (no-expert for this solution), we read the fields of the table but we can not read a hierarchy of accounts that would be RGP1 ​​or RGP2 or an attribute of accounts that would be RGP1 or RPG2

Of course, you can filter in a Qlikview report, but you have to do it every month manually.

Question 1: Can one during extraction make a grouping on an attribute (ownership of the account) or a hierarchy of accounts?

Question 2: If the solution to question 1 is not possible, can we create hierarchy nodes in qlikview permanent, ie we can use again during the next extraction

Thank you

Bastien

0 Replies