Is deta model of BI Publihser shows data with distinct in report?
Hi Experts:
In BIEE Answer:
Currently, if there are same value in the DB, BIEE displays data with distinct option.
eg:
- In the DB
Value1 Value2
-----------------------
1 A
1 A
1 B
2 C
2 C
- current BIEE Answers Request show:
Value1 Value2
-----------------------
1 A
1 B
2 C
Question:
If use BI Publisher data model to create data(eg: SQL Query, XML File...) not BI Answer,
it will show result in report as the same as BIEE Answer Request(displays data with distinct)?
If there any constraint in BI Publisher?
Regards
Sun