Hai

I have a business view about saving transactions.
It consists of two measures: number of saving-contracts and number of transaction (value of 1 for each transaction).
And it has four dimensions: day, week, month, year.
Per transaction there is a row.

What I want is per day the number of saving-contracts and their transactions. But be aware, if somebody does two transactions in a day, in the report number-of-contracts will be 1 and number-of-transactions 2.
I want the same for week, month and year. Whereby the number-of-transactions sum up, but even if somebody makes 500 transactions we still talk about 1 contract. So for the number-of-contracts I don't want that multiplicative element.

Furthermore I want to be able to drill up and down.

We are using Webfocus 8.2.04, InfoAssist+. I want to build the functionality in InfoAssist. How can I do that?
I hope someone can help. Thnx in advance

Regards
Ron

This message has been edited. Last edited by: FP Mod Chuck,

Does anybody has a clue?

You may need some IB training/courses

I cannot tell you in IA+ how to do it since it's difficult to "show" the steps needed in a UI within text.
But in FOCUS you should start with something similar to this to have your data:

TABLE FILE abc
SUM CNT.DST.CONTRACTS
    TRANSACTIONS
BY YEAR
BY MONTH
BY WEEK
BY DAY
END

In IA here's what you need to do:
1. Place Transactions and Contracts under Sum.
2. Right Click Contracts, More, Aggregation Functions, Count Distinct.
3. Place Year in By.
4. On the Menu Bar, click Format, Auto Drill.
5. Run.

If Year is in a hierarchy of Year, Quarter, Month, Day, the report will show you the total number of transactions and the count distinct of Contracts by Year first. Year will be a Hyperlink which allows you to go up and down the hierarchy.

Thanks for the answers.
The most important part is the hierarchy.
We have separate dimensions / masters for year,month,week,day.
Do I have to build this hierarchy in one master file?

If you're talking about a cluster master that joins a bunch of dimension masters to a fact table master, then I suggest you take a look at wf_retail.mas sample provided by IB. That's a very good example of how you can create hierarchies. I believe the individual masters are flat (without DV's) and when you join them in the cluster master, you create the Dimensional Views and Folders with hierarchies.

And that is exactly what I need.
I am creating a cluster join / business view+ of individual masters and for the time dimension I want to add a hierarchy in my business view+. I would love to read somewhere some kind of an instruction how to do that.

Create master files for the Fact table and all the dimensions without BV's.

Then either in the reporting server console or from App Studio, create a new synonym and join the fact to all the dimensions.

At this point you can start building your folders and assign them hierarchies.

This might be a good starting point. https://webfocusinfocenter.inf...ng/source/join84.htm

OK. Building the business view won't be the problem. Done that multiple times in the console using 8.2.04. But assign hierarchies and get them working is totally new to me.

The way I learned how to do this is to create a dummy master and played with the different ways of adding folders and such. Right click on a field or segname and see what choices you get and experiment with different options till you get it right. I used WF_RETAIL.MAS as my guide.

Thnx

case closed

Regards
Ron