Question:
Hi,
I am using an infoset with 2 ODS and one InfoObject. This is in the HR module, and all of them are linked via 0EMPLOYEE. I also have a KF in one of the ODS (ADDRESS ODS) called Count, which has a value of 1 for each record, the idea being that if an employee has more than one address the count would show that number. When I run a query with count in columns and 0EMPLOYEE in rows... the value of count is not what I expect. It shows one or more records for each employee but the value of count does not match. I get a value of 3 when there is one record and 6 (for eg.) when there are 2 records for one employee. I think this is becuase all the three IPs have 0EMPLOYEE in them, and when an InfoSet is created it holds three records for each 0EMPLOYEE.. one from each InfoProvider in the join. Is there any way to maintain the record count of an InfoProvider used in an Infoset? Also is there anyway to view the data in an InfoSet in BW? Any suggestions are welcome.
-BeW
Answer:
An InfoSet is just another InfoProvider, so you can view the data in BW by creating an InfoSet Query.
Run BEx Query Designer and open the InfoArea where you put the InfoSet when you created it, and it should be shown as an InfoProvider there.
Bob