Issue with federation of Hana and Oracle DB
27 views
Skip to first unread message
Jean-Pierre Hoedenaeken
Jun 8, 2017, 2:01:52 PM6/8/17
to OBIEE Enterprise Methodology Group
I'am facing an issue when federating data (budget and actuals) from an Oracle database and a Sap Hana database.
Does anyone have experienced issues with federating Hana database and other databases ?
Thx.
Christian Berg
Jun 8, 2017, 2:02:48 PM6/8/17
to obiee-enterpri...@googlegroups.com
Federation is nothing but an in-memory stitch join between two data sets. What is your precise issue?
Stewart Bryson
Jun 8, 2017, 2:24:14 PM6/8/17
to <obiee-enterprise-methodology@googlegroups.com>
How are you federating? Two logical data sources in the same logical table? Did you set the federation content correctly?
Give us a few more deets and I’m sure we can help.
Stewart
--
--
You received this message because you are subscribed to the Google
Groups "OBIEE Enterprise Methodology Group" group.
To post to this group, send email to
obiee-enterpri...@googlegroups.com
To unsubscribe from this group, send email to
obiee-enterprise-met...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/obiee-enterprise-methodology?hl=en
All content to the OBIEE EMG lies under the Creative Commons Attribution 3.0 Unported License (http://creativecommons.org/licenses/by/3.0/). Any content sourced must be attributed back to the OBIEE EMG with a link to the Google Group (http://groups.google.com/group/obiee-enterprise-methodology).
---
You received this message because you are subscribed to the Google Groups "OBIEE Enterprise Methodology Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to obiee-enterprise-met...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Christian Berg
Jun 9, 2017, 6:23:31 AM6/9/17
to obiee-enterpri...@googlegroups.com
Ongoing OTN thread. Looks like incompatible result sets from the two sources.
On 8 Jun 2017 8:24 pm, "Stewart Bryson" <stewar...@gmail.com> wrote:
How are you federating? Two logical data sources in the same logical table? Did you set the federation content correctly?Give us a few more deets and I’m sure we can help.Stewart
On Jun 8, 2017, at 2:02 PM, Christian Berg <christia...@gmail.com> wrote:
Federation is nothing but an in-memory stitch join between two data sets. What is your precise issue?On Thu, Jun 8, 2017 at 7:18 PM, Jean-Pierre Hoedenaeken <j...@rtbf.be> wrote:I'am facing an issue when federating data (budget and actuals) from an Oracle database and a Sap Hana database.Does anyone have experienced issues with federating Hana database and other databases ?Thx.--
--
You received this message because you are subscribed to the Google
Groups "OBIEE Enterprise Methodology Group" group.
To post to this group, send email to
To unsubscribe from this group, send email to
For more options, visit this group at
http://groups.google.com/group/obiee-enterprise-methodology?hl=en
All content to the OBIEE EMG lies under the Creative Commons Attribution 3.0 Unported License (http://creativecommons.org/licenses/by/3.0/). Any content sourced must be attributed back to the OBIEE EMG with a link to the Google Group (http://groups.google.com/group/obiee-enterprise-methodology).
---
You received this message because you are subscribed to the Google Groups "OBIEE Enterprise Methodology Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to obiee-enterprise-methodology+unsub...@googlegroups.com.
--
--
You received this message because you are subscribed to the Google
Groups "OBIEE Enterprise Methodology Group" group.
To post to this group, send email to
To unsubscribe from this group, send email to
For more options, visit this group at
http://groups.google.com/group/obiee-enterprise-methodology?hl=en
All content to the OBIEE EMG lies under the Creative Commons Attribution 3.0 Unported License (http://creativecommons.org/licenses/by/3.0/). Any content sourced must be attributed back to the OBIEE EMG with a link to the Google Group (http://groups.google.com/group/obiee-enterprise-methodology).
---
You received this message because you are subscribed to the Google Groups "OBIEE Enterprise Methodology Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to obiee-enterprise-methodology+unsub...@googlegroups.com.
Jean-Pierre Hoedenaeken
Jun 12, 2017, 12:57:30 AM6/12/17
to OBIEE Enterprise Methodology Group
But how can we explain that the resultes are correct when I put a filter on an employee number ?
Does the clause "Fetch First .... Rows Only" in the logical SQL play a role in the game ?
Thx.
Le vendredi 9 juin 2017 12:23:31 UTC+2, Christian Berg a écrit :
Ongoing OTN thread. Looks like incompatible result sets from the two sources.
On 8 Jun 2017 8:24 pm, "Stewart Bryson" <stewar...@gmail.com> wrote:
How are you federating? Two logical data sources in the same logical table? Did you set the federation content correctly?Give us a few more deets and I’m sure we can help.Stewart
On Jun 8, 2017, at 2:02 PM, Christian Berg <christia...@gmail.com> wrote:
Federation is nothing but an in-memory stitch join between two data sets. What is your precise issue?On Thu, Jun 8, 2017 at 7:18 PM, Jean-Pierre Hoedenaeken <j...@rtbf.be> wrote:I'am facing an issue when federating data (budget and actuals) from an Oracle database and a Sap Hana database.Does anyone have experienced issues with federating Hana database and other databases ?Thx.--
--
You received this message because you are subscribed to the Google
Groups "OBIEE Enterprise Methodology Group" group.
To post to this group, send email to
To unsubscribe from this group, send email to
obiee-enterprise-methodology+unsub...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/obiee-enterprise-methodology?hl=en
All content to the OBIEE EMG lies under the Creative Commons Attribution 3.0 Unported License (http://creativecommons.org/licenses/by/3.0/). Any content sourced must be attributed back to the OBIEE EMG with a link to the Google Group (http://groups.google.com/group/obiee-enterprise-methodology).
---
You received this message because you are subscribed to the Google Groups "OBIEE Enterprise Methodology Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to obiee-enterprise-methodology+unsub...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
--
You received this message because you are subscribed to the Google
Groups "OBIEE Enterprise Methodology Group" group.
To post to this group, send email to
Christian Berg
Jun 12, 2017, 12:59:24 AM6/12/17
to obiee-enterpri...@googlegroups.com
One specific employee number will retrieve one granular employee record. Your other examples are aggregates so maybe the dimensional attributes used to aggregate the different data sets aren't in synch.
On 12 Jun 2017 6:57 am, "Jean-Pierre Hoedenaeken" <j...@rtbf.be> wrote:
But how can we explain that the resultes are correct when I put a filter on an employee number ?Does the clause "Fetch First .... Rows Only" in the logical SQL play a role in the game ?Thx.
Le vendredi 9 juin 2017 12:23:31 UTC+2, Christian Berg a écrit :
Ongoing OTN thread. Looks like incompatible result sets from the two sources.
On 8 Jun 2017 8:24 pm, "Stewart Bryson" <stewar...@gmail.com> wrote:
How are you federating? Two logical data sources in the same logical table? Did you set the federation content correctly?Give us a few more deets and I’m sure we can help.Stewart
On Jun 8, 2017, at 2:02 PM, Christian Berg <christia...@gmail.com> wrote:
Federation is nothing but an in-memory stitch join between two data sets. What is your precise issue?On Thu, Jun 8, 2017 at 7:18 PM, Jean-Pierre Hoedenaeken <j...@rtbf.be> wrote:I'am facing an issue when federating data (budget and actuals) from an Oracle database and a Sap Hana database.Does anyone have experienced issues with federating Hana database and other databases ?Thx.obiee-enterpri...@googlegroups.com--
--
You received this message because you are subscribed to the Google
Groups "OBIEE Enterprise Methodology Group" group.
To post to this group, send email to
To unsubscribe from this group, send email to
For more options, visit this group at
http://groups.google.com/group/obiee-enterprise-methodology?hl=en
All content to the OBIEE EMG lies under the Creative Commons Attribution 3.0 Unported License (http://creativecommons.org/licenses/by/3.0/). Any content sourced must be attributed back to the OBIEE EMG with a link to the Google Group (http://groups.google.com/group/obiee-enterprise-methodology).
---
You received this message because you are subscribed to the Google Groups "OBIEE Enterprise Methodology Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to obiee-enterprise-methodology+unsubs...@googlegroups.com.
--obiee-enterpri...@googlegroups.com
--
You received this message because you are subscribed to the Google
Groups "OBIEE Enterprise Methodology Group" group.
To post to this group, send email to
To unsubscribe from this group, send email to
For more options, visit this group at
http://groups.google.com/group/obiee-enterprise-methodology?hl=en
All content to the OBIEE EMG lies under the Creative Commons Attribution 3.0 Unported License (http://creativecommons.org/licenses/by/3.0/). Any content sourced must be attributed back to the OBIEE EMG with a link to the Google Group (http://groups.google.com/group/obiee-enterprise-methodology).
---
You received this message because you are subscribed to the Google Groups "OBIEE Enterprise Methodology Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to obiee-enterprise-methodology+unsubs...@googlegroups.com.
--
--
You received this message because you are subscribed to the Google
Groups "OBIEE Enterprise Methodology Group" group.
To post to this group, send email to
Reply all
Reply to author
Forward
0 new messages