PowerPlay Transformer warning TR0220 - Temporary file for PowerCube is Empty

[bt2133]

Hello,

Has anyone seen this error before? And do you know how to correct it?  I build cubes monthly, and I have built this particular cube with no problems for months now. Suddenly, I can not build it anymore because the source file no longer collects data.  I have run the PYI file in Impromptu and it does not collect data, which explains the error TR0220 that I receive and why my cube won't build.  What I don't understand, is why there is no data. The structure of my PYI file has not changed and I have not had this problem in the past.  I have figured out which field in Impromptu is causing the error, but I can not for the life of me figure out why.  Any help or advice would be greatly appreciated.


Thank you,
Brian

[Darek]

This happened to me recently, when I've excluded lowest level from a dimension, in hope that I will only have the higher level summaries. Had to use a Custom View instead.

[awilbourn]

This is an old post, but faced this problem today. We had just moved some new schema to a test DB server and pointed everything thing of to test. We had built cubes prior against another server and things built just fine. For us the issue was permissions were wrong on the new DB server and so a process to populate data to a dimension failed and left the table empty, so the cube query did not receive any data back as we inner join to the dimension with no data. Resolved the permission problem and ran the job that is to populate the data where the query returned rows and everything was just fine. So I figured I would post this to help someone else searching that if you return no data from a query it can cause this problem. So ensure your queries to build the cube return data from every query in the model.