Search results for query: *

hey all, I'm going to start preparing for 445 and 446 soon and I was wondering whether any of you took this one and got some good books, braindumps and/or study guides for me. Everything to help me with this is helpful, thx in advance!

Hi there, I am trying to add a calculation to the cube that shows how many products were sold. This means that I actually have to count the members of a dimension that gave > 0 for a certain measure (amount sold). Any ideas? Do you guys recommend any books covering MDX btw, it seems I'm getting...

Hey all, I am making a cube representing the stock historically. We managed to get the amounts in the cubes, only now we have a problem with cost- and salesprices. The thing is the lines in the database have the amount of a certain item in a certain store on stock, AND the line also has the...

Hello peeps, Another thing I can't get out of that probably has a simple solution. Powerplay Transformer (7.1) I have a cube with a lot of different datasources. 2 of them are linked to the margin (you don't wanna know how our datastream is in here... horror). The first one gives the margin for...

Hey, Ok, disregard my previous post "Catching orphans". I found out where the orphans came from and solved all of them... Except one dimension keeps having some. But I found out what triggered this. A .csv-file that is generated by a server every week and that I am using. Now when I add this...

For instance... in a cube I'm building I have several stores grouped. Some of these stores (for instance old ones) do not fall under a certain category and are therefor registered as orphans. I have these "orphans" in several other dimensions in the cube. Is there a way to bundle these orphans...

I am making a report about an order containing multiple products. These products have multiple prices with in accordance multiple dates which reflects when these prices became effective. In this report I only need the most recent prices for every product. It ain't a problem to get the most...

I am making a revenue-report. In this report I use percentages in one column. Now I make some summarizes but since there are some values giving "/0" (divided by 0), the summary gives /0 aswell. Is there a way to let powerplay NOT include these values in the summary without making seperate...

I have a dimension "Group Codes" and they contain 4 digit combinations. I created some subsets which divides this is several groups, depending on what digit the group code starts with. Now this subset is generic, meaning that if I refill the cube, new groups will automaticly fall under the...

I am making a report on daily figures of our stores. I am, in this reporting, comparing figures from 'today' against 'today Y-1' (being the same day, last year). Now at this time, when I select a 'same day, last year' he gives the same day as in: today: 2004/03/13 today (last year)...