getting a "No Table found for fact name" message
I have inherited the maintenance of a pentaho/mondrian data warehouse. I am trying to add a new cube to the list of cubes and it depends upon a new fact table I have created in oracle. The fact table and the aggregates are present and I have modified the needed xml table for defining the cubes. However when the xml is read/parsed in the pentaho log I get the message "WARN [mondrian.rolap.aggmatcher.AggTableManager] : No Table found for fact name=" and the name of the fact table. I cannot determine what this means. I know that the fact table is indeed present and in the same schema as all the other fact tables. Any suggestions?
Mondrian retrieves the list of tables from the jdbc connection. That warning will be logged if the table name is not in the list retrieved via the metadata call. You've probably already done this, but I'd want to triple check naming and permissions.
Originally Posted by mcampbell
I am also facing the same problem, infact the original post clearly says,
"The fact table and the aggregates are present"
"I know that the fact table is indeed present and in the same schema as all the other fact tables."
I did not find proper response for this question, so posting it again. Hope someone is looking into it as this is very old post (year 2013)
In my case also, the face table is very well exists (no spelling mistakes).
Please look at the link below.
Which says, "One with the dimensions (the fact table) and a one-to-one relationship with the second table that contains the levels" I meant "One with the MEASURES (the fact table) and a one-to-one relationship with the second table that contains the levels"
Even tried this, but same error
07 Mar 2017 11:12:54,946 WARN [Session ] mondrian.recorder.AbstractRecorder#logMessage: : No Table found for fact name=trendday_old
1. If I keep only measures, there are no issues. Mondrian is able to fetch the meta data for measures.
2. I tired the exact schema with MY SQL, interestingly it is working fine for both dimensions and measures. But for MS SQL it is not able to identify the fact table. For me it looks like a bug, or we have define the xml file for cube definition in some different way (not sure), please help.
Last edited by vishwanathbk; 03-07-2017 at 01:35 AM.