Forum Discussion

Acarrier's avatar
Acarrier
Frequent Visitor
5 years ago
Solved

PowerBi summarizes Oracle query (view) data incorrectly by date

Hi All,    Some data in a power Bi report is an oracle view about numbers for a work shift. Each day has 2 shifts, 1 and 2. Basically the Key is the prod_date and prod_sh. See the query below retur...
Need Help
  • Acarrier's avatar
    Acarrier
    5 years ago

    Hello Evelyn,

     

    THanks again for your input, it is appreciated. 

    The object in question is a view, a union of other tables/joins. 

    I just solve my issue. I ended up using a pipelined function. In oracle a pipelined function is a function that acts like a table. You can make a view off of a pipelined function. This is what I did. Somehow this solved the issue. I cannot explain how this solved it and why the original view was a problem. I tried many thinks. My view was a summary. I tried a view that was all the detail rows. The same fields were wrong as well. 

     

    I am at a loss, but I found a reasonable workaround. 

     

    Thanks!

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Acarrier ,

 

I think it's caused by the relationships built in oracle.

You may try to

1. Add a Index column to the table.

2. Delete the relationship

3. Or uncheck the "Include relationship columns"option

For more information,you can refer to this:

How to Create and Use Indexes in Oracle Database

Remove an entity, attribute or relationship

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Acarrier's avatar
Acarrier
Frequent Visitor
5 years ago

Hello Evelyn,

 

THanks again for your input, it is appreciated. 

The object in question is a view, a union of other tables/joins. 

I just solve my issue. I ended up using a pipelined function. In oracle a pipelined function is a function that acts like a table. You can make a view off of a pipelined function. This is what I did. Somehow this solved the issue. I cannot explain how this solved it and why the original view was a problem. I tried many thinks. My view was a summary. I tried a view that was all the detail rows. The same fields were wrong as well. 

 

I am at a loss, but I found a reasonable workaround. 

 

Thanks!