x.xsl is xsl template DM_Dialer is xml data

Set 'Disable External Reference' -> 'False' in props of report. After run up - all ok

Hi Christian! It's very usefull link, thanks! But we have to monitor time to time (about 1 minute .. for example ) OBIEE nodes from balancer-node by http(s) And we solved this problem for a while: - Balancer node ask Node1 about http://my_node1:1111/analytics/saw.dll?BIEEHome&startPage=1 If get 200 - node is alive If not -…

Joel thanks you What artefacts i will found? I understand ..there is some risk do migration by export-import BAR. I cannot find any doc on support.

Thanks Christian! That's work But i have some problem with Employee now due to i formed on day and plan_monthly_table on month and have to connect Empl on first day of month (just like this: "PRECLEMP_REP_DATE" = "PLAN_DATE_MONTH" AND "PRECLEMP_EMPL_LOGIN" = "EMPL_LOGIN") so Employee may be not exist on first day of month…

Hmm after your words i begin hesitate So Partner(Client) has Accounts. From this Accounts Parther do Payments. That's all architecture. I realy could not understand why we need divide fact & dim on phisical layer.. for a while.

So i recreate phisical level diagram Is'it good for obiee ?

Ok i will go on step by step. Did youn mean i should to divide(artificaly) my datamart's on phisical layer?

Ok Is any way to solve this task? Without publisher! No any action from business with: formula, filter definition and so on? Could you show me project OBIEE with multifact tables ?

So first step target : For each client i need calc count account , and count payment. in the same analiz

I create analyse with using Client and Account it's calculated fine and give me correct result When i add Payment measure - it's null When i add formula with like: count distinct payments by client.id it work so i show it on pic

Many formulas on Payments is just calculated from Addons - I will remove it. I can include it in DataMart of payment. Is't help me?

So i make analysis with mix Client, Account, Payments - usually business want everything :) When i count payments by formula - all ok when i count payments from measure of Payment _Fact -it's not working.

-------------------- SQL Request, logical request hash: cd65f190 set variable LOGLEVEL = 7;SELECT 0 s_0, "Kaspi Business - Платежи"."Календарь"."Месяц (Дата)" s_1, "Kaspi Business - Платежи"."Партнер"."Активен - 1 мес" s_2, "Kaspi Business - Платежи"."Партнер"."Активен - 3 мес" s_3, "Kaspi Business -…

Yes one table is datamart with dimensional data and fact data. I divide at BMM layer on two: fact & dim There is no aggregate data indeed. But for a while i don't need them. I have to understand power of OBIEE. May be there is no any power :) One fact&many dimensions - it's not in real world. I try understand how it work…

It's additional attribute for CLIENT. Dees it impact on SQL generation between? So i remove it join, but nothing change

My phisical layer LINKS BMM

Hmm when i write formula in analize just like this: count(distinct("Payment"."ID") by "Client"."ID" ) - all work perfect! None formula (a lot!) in BMM on Payment is not working :( So due to your link's & advice i have to check all my work again and again. I will be back Thank a lot about your assistance

Btw - I would never expect to see a direct join between 2 fact tables - payment / account above - if your previous diagram is correct? previous diagram is Phisical ! Not BMM Sorry Robert i have to translate/and redraw so much for show your. I cant do it quick

In logical query i see Payments: ... CountPay:[DAggr(Payment(F).Count by [ Calendar(Month), Client.ИИН, Client.Активен - 1 мес, Client.Активен - 3 мес, Client.Наименование, Client.ТОО ИП, Client.Тип Clientа] )] as c9 , -- But next CountPay converted to NULL because [nQSError: 14020] None of the fact tables are compatible…