Hi Shantaram, By including that dimension table, 2 additional filter conditions are being added into the query, and no matching record with that key ID column exists, seems that might be causing the issue. Thank you.

Hi Shantaram, a. For all users b. None c. yes d. Can't share Thank you.

Thanks Chris. Its an "analysis", not a report.

Thanks Gianni. These are analysis. As its production env, logging disabled. Possible option(s): Set CACHE Enable to NO in NQSConfig file (right now its YES) Please throw in some suggestions might help in getting latest data. Regards.

Hi Chris, Now i understood what you conveying in the above example, but in my case i don't need any column from Fact-B, all i need is to pull columns from Dim-A and Dim-C. (i am sure you aware that i don't have a Dim-B in my model), I went ahead and did the changes in Fact-B as you mentioned, and then added a column from…

Hi Gianni/Chris, The logical tables are as follows. Dim A has data about various courses names and the institute that provides them. Dim B has details of the instructor for the courses. So if i navigate to physical layer, i could find a column called course number (6 digit code) that is common between the two tables. Now…

Thanks Chris, but let me give a quick overview. Below is how my 2 dim tables and 2 fact tables are joined in BMM. Dim A -----join------- Fact A Dim B -----join------- Fact B Now when i pulled columns from Dim A and Dim B, i faced "[nQSError: 14025] No fact table exists at the requested level of detail:" In the BMM both Dim…

Now i identified common columns between Dim A and Dim B tables and created a join between them in physical layer. So do i need to create business model again so that it assumes the new join created in physical layer OR is there a way i could save all that rework so that existing business model assumes the new join created…

Thanks Gianni, but i don't see any common columns between the tables Dim A and (fact B or Dim B) OR Dim B and (Fact A or Dim A) so that i can create joins. Wonder if adding Dim B as an LTS for Dim A make it work !!?? Thanks.

Hi Gianni, It is not on any dashboard. Its just an analysis in catalog and an agent used to deliver this report. Yesterday it did not got delivered. So we went into catalog and manually tried running and ended up with the error posted in the question. Data source is MS SQL Server 2016. Thanks

Hi Chris, Its a simple table visualization. This error appears when i browse the catalog and hit "Open" on this report. Thanks.

Hi Chris, In the analysis "edit" view (in answers), all the columns in criteria are direct columns from subject area (no calculations at answers level), it has 6 filters of which one is having a "TIMESTAMPADD" function and the rest are again simple filters like greater than, is equal to/is in, some date is equal to (a date…

Hi Gurus, Any update on this please.. Thanks.

Hi Gianni, Issue is there is an extra space in the name of that catalog object in the agent's delivery content tab. Once we reselect the report using "browse" button, it resolved the issue. Thank you.

Thanks Gianni and Chris.

Thanks Gianni, this sounds good but wonder what else we can do if user A is no longer a valid user (left an year ago)

Thanks Gianni.

Agree, so you mean logging should be enabled (set a minimum of 2) for ALL users in prod ? Cache -- ideally should it be turned ON in prod ? Please specify.. Thanks in advance.

This being a production environment logging is disabled for all users and don't think stale data (cache) might cause the agent to fail. But as you said people may not be true always. As we have limited options to further investigate this, wondering how to proceed further.. Thank you.

Hi Gianni, Agree with you but i did checked the "condition" for this agent and the users are sure that they have counts updated last friday and this agent delivered report on all previous saturdays as well, only this time it did not. And this morning the report with yesterday's counts is delivered as it normally does.…