Search results for query: *

Thanks everyone! Well, I've been working with all the SQL 2005 services, mainly on SSIS and SSAS, for the last year as a BI Consultant. Still, since this is the first certification of MS I will be taking, I don't really know what to expect. The Training Kits from MS will be available this...

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!

You'll have to take this up on database level en put FK's from the employee-lines that point to the department and customer keys. Then you can build a hierarchy out of these three after you defined the connection in your data source view.

The analysis services is in the SQL2005 but if you want to develop dimensions and cubes, yes, you need VS2005 but there is a BI edition of that called "BI Development Studio" included in the package if I'm not mistaken. Same thing for Integration Services and if you liked DTS you sure will LOVE...

I don't know if an upgrade is needed. With SQL2000 you also get Analysis services and, if you want to get further, reporting services. SQL2005 in my opinion is more of an improvement if you want to do serious ETL. As for books, the usual will do (Wrox, Kimball,...). I got myself mainly SQL 2005...

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...

I think the best way to achieve this is by creating a view on the database and adding a filter on there to say they only have to take the last 10 months.

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...

Unfortunately no, Cube has other measures and day level is needed for other purposes =/ I'm not quite sure that would work either... All the other days get a zero by default which causes troubles for the average rollup

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 Hellopin. Hmm, difficult question there to really answer in full. With Impromptu there normally comes a quite good manual and loads of examples. I personally learned a lot on my own and, off course, from someone who sat beside me as I took my first steps in it. Another option is to go to...

And this as a cry from the help department: Cognos, PLEASE put this as a standard calculation in next release...

Thanks for the heads-up! I was wondering whether here at our company we should move to reportnet. What's the big diff with Upfront? Anyone wishes to share his or her points on the pro's and con's?

Yeah, indeed, that's what I did and that took care of the error, but now these dates come as orphans as where the other dates (from other sources) come through in the correct categories (as in weeks, months etc). (The data in this .csv does not span the entire period, only a couple of weeks of...

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...

That's how I did it aswell. Although I am following a Transformer OLAP modelling training at the Cognos Center in a couple of weeks...

Shindhu, I don't think I totally get what the problem is. You want a Prior WTD. So let's say it's friday today in week 24, then you expect the total from monday to friday but from week 23, correct? What are you getting now then?

As drlex said the .IQD is a kind of a "port" to the actual database for the cube. See it as a map transformer uses to find de data in de database. Now once the data is fetched from the databased it's staticly stored in that cube. So whatever your users may do, they're only playing the cube, NOT...

What I usually did (but is slightly to much effort according some for what it's worth) is put this data in a table in the database I work in, then make a impromptu report only selecting the column with those codes, save the report. When you then go to your original report you can say in the...

Here's what I used in the macro for that: 'Open Impromptu Set objApp = CreateObject("CognosImpromptu.Application") trueName = path & fileName & ".imr" Set objRep = objApp.OpenReport(trueName) strExcelFileName = path & fileName 'Save As Excel...