Hi, thank you. Do you have experience how much time more or less does it take to launch Usage Tracking from scratch?

Don't do the case statement with your ago() I guess that's the reason why it is not working, but why? Is it forbidden to do case statem with Ago function? I didn't know that before. You'vew already started in the direction I would point you - back to the database. Yes, that's what I am going to do. @cesar.advincula.o It's…

Okay here we go: on first screen column1 and column2 and my measures which we're discussing. As you can see both show the same value which is obviously wrong. Additionally I added two other measures (not connected with this topic) that show correct values. And for the record I'm putting how these measures look in admin…

Thank you for your effort, I need to check it deeply. I will let you know on Monday.

Christian, but my requirement is to present it for every level, not for only one specified. Anyway as I said, I tried also with defined level and problem was still the same. @cesar.advincula.o It is quite simple: I have fact Customers and dimension Time. They are joined i BMM and in physical layer. Everything else stay as…

Sorry Cesar, I was unclear. I'm using this measure on fact, not dimension. So it is not a problem. @Thomas Dodds I don't think it is needed. In that case OBI is displaying values based on what Time attribute you use. For example if I use put on analysis Month it should show me values from previous month. If year - it…

In RPD, but I tried in analysis too and didn't work as well. And actually I said what is the problem. Problem is that Measure with Ago function (Number available) shows the same values as Measure without Ago function (Number available previous period). What else can I say? @cesar.advincula.o yes exactly

I don't think it's relevant beause this table joins actually 3 different tables.

Thank you for the answer, 1. How is the logical star schema relevant to logical levels for column? I cannot see any connection. You say Notice that the for example DocumentoPagarDim is not part of the Star Schema, but still, what does that change in your example? 2. Second thing is that I have more than 2 logical…

Thomas, I understand your point, however it's not essential problem in this topic.

Not exactly, in first post I simplified it a bit. I have one fact table in business model with measures from accruals, redemptions, reversals. So essentially each table is LTS as well. And additionally two dimensions like on the picture: snaggy - paste images! @Thomas Dodds I know about it but table Transactionrelations is…

Ok this is more or less my case: http://snag.gy/bnooP.jpg The thing that if I create for example report with columns from Reversals, Redemptions, Redemptionpartner, I would like to use in select only these tables + Transactionsrelations, but instead of this OBI does select with all these tables that are in the picture.

Any ideas? I think I can create second LTS (with different joins) and duplicate this measure but it is kinda avoiding problem, not solving it.

Hello, as I said I simplified this model but let's say that yes, I have only LTS and 6 dimensions. These dimensions have more attributes but on my first report I use only one attribute from each dimension. And in second case where I use only some of these attributes I don't want to have in select all those dimensions (as…

So please tell me if I understood correctly, In my case I should set content level in fct_trn_redemptions table (this is the table where third column comes from) as PartnerR Details? Because if so, it didn't work. Anyway I would be greatful for any ideas how to solve my problem, I am really stuck with this.

well it's kinda complicated...Our databse is built in way where this the only one relation that work for both partners. Anyway it works in databse so I guess it should work in OBI as well.

I've seen this link before, however I'm not sure how to apply it in my case. My physical layer looks like this (all columns have connection): The third column is from fct_trn_redemptions fact which joins to first partner directly and indirectly to another one so I don't really understand why are you saying that my fact is…

Yes of course: [2016-01-07T09:21:19.000-02:00] [OracleBIServerComponent] [TRACE:2] [USER-0] [] [ecid: 3ebfd888e3312216:-672f59a9:151a16fd3ec:-8000-00000000001865a7,0:1:1:3] [tid: 1ab7b700] [requestid: 2c980008] [sessionid: 2c980000] [username: weblogic] ############################################## [[--------------------…