I hope someone can help with this question. I have a BOI universe that’s tracking jobs. It’s organized by tasks with task start and end dates. Looks something like this :
Job Task Start End
1 A Week1 Week3
1 B Week3 Week4
4 A Week1 Week2
4 B Week2 Week4
7 A Week2 Week3
7 B Week3 Week7
I need to count the number of jobs in a task in a given week. Should group the jobs like :
Week1 Week2 Week3 Week4
A 1,4 1,4,7 1,7 1
B 4 1,4,7 1,4,7
And then count like :
Week1 Week2 Week3 Week4
A 2 3 2 1
B 1 3 3
I have created quite a few different variables but so far can only get BOI to “see” the job in the task’s first week. It won’t continue putting the job in later weeks.
Regards,
Ann Moore
E-mail : amoore@ti.com
Phone : 972-480-1798
Texas Instruments
I’m struggling with this and I know I’ve done it before but I can’t get it to work this time…
I have a data provider that has sales information and calculates some weighted averages. I need to display the product number and name for the product that is the sales leader in the group. Everything I’ve tried either gets me the #multivalue or a #computation! I know this is simple, but I’ve looked at it so long, I’m not seeing it the right way. Any suggestions?
You are not alone. I use BO’s “Advanced Calculations & Troubleshooting Guide” & Dave Rathbun’s Variables and More at www.islink.com, for my variable woes. Usually I report my data at the detail level, build formulas, then Define As Variable. Next I fold on logical summary dimensions (or just create summary tables) to check dynamic use. Usually I have omitted “Sum” in my formula - or sometimes “In” or “For Each” whatever.
If you are simply putting a product and description together, you have a couple of options. The easiest is to simply concatenate them in a universe object or report variable.
If you don’t want to do that, create your master out of the Product Number. Drag your description up to the same level. If you are getting multivalue, just change the object to “max()” and see what happens.
The problem with max() is that it gives me the max(). What I really need is the description of the max()…Any idea how I can do that? I’ve already set everything together to contatenate the heading and I’m using that as a master. The requirement is to report the summary data for the majority of the key and the most highly sold product number/description for the heading on the page. I think they were trying to make it simple for people doing this on a more manual basis…
If you are simply putting a product and description together, you have a couple of options. The easiest is to simply concatenate them in a universe object or report variable.
If you don’t want to do that, create your master out of the Product Number. Drag your description up to the same level. If you are getting multivalue, just change the object to “max()” and see what happens.
The problem with max() is that it gives me the
max()
.
What I really need is the description of the max()…Any idea
how I can do that?
My suggestion would be to make a separate table block, and use the Rank feature. Find the “Top 1” description based on the measure object of . That’s about the only way I can think of to get this to work.
If you try to do the same thing within your current block, it will be very difficult.