Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. kdemulder

    70-445 & 70-446: call for info

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

    70-445 & 70-446: call for info

    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!
  3. kdemulder

    Hierarchies in Analysis Serivces 2005

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

    Any good books?

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

    Any good books?

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

    MDX to calculate number of products sold

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

    Date Variable

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

    Show amount at current prices

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

    Allocate a measure that contains data per week to every date

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

    Allocate a measure that contains data per week to every date

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

    Impromptu

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

    Number of Weekdays in Time Period

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

    ReportNet Feedback

    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?
  14. kdemulder

    Date definition in .csv other then in other data sources

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

    Date definition in .csv other then in other data sources

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

    Understanding Cognos Cubes

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

    WTD and Prior WTD

    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?
  18. kdemulder

    Cube Creation via .iqd

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

    Filters

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

    MACRO : Improptu report to Excel

    ...strExcelFileName & ".xls" objRep.CloseReport objApp.Quit Set objApp = Nothing Set objRep = Nothing Couple of warnings: * This is for 7.1! * make a variable "path" and "filename" and give them the appropriate values * there is a difference when you save it WITH...

Part and Inventory Search

Back
Top