That's phisical schema

Ok i did 2 new hierarchies: H-Client (Total level and just detail with PK attribute) H-Account (Total level and just detail with PK attribute) Also i have to make Fact table for Client (cause connection with Calendar not working properly) And total i have 3 fact tables (Client(F), Payment(F),Account(F)) On a LTS Fact table…

Did you mean i have to do make hierarchies based on Client and Account too?

Ok Thank a lot Joel, Gianni, Christian, Robert for your advise! Now i make calendar with level-based hierarchy. H-Calendar(month,year) I set content on LTS: Client H-Calendar to TOTAL Account H-Calendar to TOTAL when i save RPD i get: [14031] The content filter of a source for logical table: Client (D) references multiple…

That's blow up my mind :( I will try understand it.

So one Client have one or more Account from one Account client may do one or many Payments. I look about bridge table - but there is no need to do bridge table. Seems..

There is no any good master of obiee around :) When i ask question about analitical using obiee my coworkers.. I get something like this : "hmm i never did this ..but... you can use publisher!" So ofcourse i may hardcode any report in publisher. But i whant business solve problem with analytic. Can you advise about good…

so i divide Dimension on 2 logical tables on BussinessLayer and calc count on fact table. That's work

So what if no record in fact table? I have to show user 0 or null count of measure.

So there is no problem count. I ask about rpd development. What if fact table consist +pair (open:close) column. Have i add in BMM +2 calendar? and totaly it will 4 calendar? "I need a more .. calendar":)

Yes that's right

NO i have to do analyz just like 01/10/201802/10/2018openned1020closed57 if issue openned at 01/10/2018 then 10+1 if some issue closed at 01/10/2018 then 5+1

Wow great! Thanks! Your way is perfect for me! because we have a very huge instance

OBIEE 12c 12.2.1.2.0 with latest patches. All version the same I see that : Security policy metadata containing application role and application role memberships plus permission and permission set grants for a service instance. But i cannot see in target instance correct set of application role.

I added condition on date column. I want change color/font when other column is 'Y'. It's not working! Why?

I want copy RPD, all Published reports, All Interactive Dashboards&Analises&Conditions&Filters

font color must change (on DATE column) when value of other column is 'Y' So table is cross-table.

Thanks! We did work on issue with export very huge XLS files. Seem's to be we forget switch off this

I see only *.javahost.in *.javahost.out there is no log files My OS version is RedHat 7 Linux appbiprod-12c.hq.bc 3.10.0-514.21.1.el7.x86_64 #1 SMP Sat Apr 22 02:41:35 EDT 2017 x86_64 x86_64 x86_64 GNU/Linux by the way i have in javahost config <XMLP> <InputStreamLimitInKB>0</InputStreamLimitInKB>…

I't strange but we have records in S_NQ_ACCT. but some of records OBIEE can't insert. I's bulk insert work incorrectly? how can stop _BULK_ insert, and use simple insert?