Qbe Query Error

Question

I have created business model and generated metamodel. While preview, following error is there. Appreciate help

An error occurred in EXEC_QUERY_ACTION service while executing query: [SELECT t_0.id, t_0.quantity, t_1.name, t_2.name FROM Samplefacttable t_0,Author t_1,Book t_2 WHERE (t_0.rel_bookfk_in_book.id = t_2.id AND t_0.rel_authorfk_in_author.id = t_1.id)]

Comments

Query generated by SpagoBI 5.2

Working fine.

select
        samplefact0_.[id]  as Id,
        samplefact0_.[quantity]  as Quantity,
        book1_.[name]  as Name,
        author2_.[name]  as Name 
    from
        [DemoDB].[dbo].[samplefacttable] samplefact0_ cross 
    join
        [DemoDB].[dbo].[book] book1_ cross 
    join
        [DemoDB].[dbo].[author] author2_ 
    where
        samplefact0_.[bookfk]=book1_.[id] 
        and samplefact0_.[authorfk]=author2_.[id]

Query generated by Knowage

 select
        samplefact0_.[id]  as Id,
        samplefact0_.[quantity]  as Quantity,
        author1_.[name]  as Name,
        book2_.[name]  as Name 
    from
        [DemoDB].[samplefacttable] samplefact0_ cross 
    join
        [DemoDB].[author] author1_ cross 
    join
        [DemoDB].[book] book2_ 
    where
        samplefact0_.[bookfk]=book2_.[id] 
        and samplefact0_.[authorfk]=author1_.[id]

Answer 1

Hi, when you generate (when you click on button "Generate" in the business model catalogue), you can specify schema and catalogue. Try to use  DemoDB as schema and dbo as catalogue

Comments

Thanks.

My problem solved.