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!

  • Congratulations SkipVought 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: *

  • Users: MiRRo
  • Order by date
  1. MiRRo

    problems with shipnotenum!!

    Hi drlex, I checked my iwr, wich I use as iqd. The data in my iwr is right. I cant see a shipnotenum in 2002 which has the same shipnotnum in 2003. Can I also modify the filter on the iqd at Transformer level??? I have multiple data sources, how can I check if I have an erroneous assocation...
  2. MiRRo

    problems with shipnotenum!!

    Hi Cognosprofessional, How do I eliminate duplicate rows? I tried to read about it but could not find any info. Do you mean with "need unique to year" that I should make year unique. In my model I already set all dates on unique. Hi Bruce, I will mail you today.
  3. MiRRo

    problems with shipnotenum!!

    Hi drlex, I have a year dimension. My date dimension is like this: Year Quarter Month Week Day Shipnotenum Cheers, MiRRo
  4. MiRRo

    problems with shipnotenum!!

    Hi people, I will tell you the problem I am facing with. I have a level shipnotenum. I put this level in my time dimension so when we drill down to level day we can see the shipnotenums at that day. Its working fine but not perfect, the reason is that I also get the shipnotes of 2001,2002 on...
  5. MiRRo

    tr1901 A BEFORE rollup cant be defined............................

    TR1901 A BEFORE rollup cant be defined for an allocated measure. (Amount (Eur)) in d:\temp\paimentstest.mdc
  6. MiRRo

    tr1901 A BEFORE rollup cant be defined............................

    Hi Draoued, When I say show scope and select the measure Amount(eur) the dimensions are getting yellow. Cheers, Murat
  7. MiRRo

    TR2331 This level is a catagory count level for one............

    Drlex, I will tell you the problem I am facing with. I have a level shipnotenum(catagory count level). This level gives us the number of shippings. I put this level in my time dimension so when we drill down to level day we can see the shipnotenums at that day. Its working fine but not perfect...
  8. MiRRo

    TR2331 This level is a catagory count level for one............

    Yes espacially on monday mornings! :-)
  9. MiRRo

    TR2331 This level is a catagory count level for one............

    Thank(1000*)you drlex!!!!! Cheers, MiRRo
  10. MiRRo

    TR2331 This level is a catagory count level for one............

    Hi drlex, Can you tell me how to that?
  11. MiRRo

    TR2331 This level is a catagory count level for one............

    Hi people, I am facing the last time with some errors. Now I get error TR2331 This level is a catagory count level for one or more measures. Therefore it cannot be deleted! I put that level into my model now I cant deleted. I could setup a new model but I want to resolve this error. Thanks, MiRRo
  12. MiRRo

    tr1901 A BEFORE rollup cant be defined............................

    Hi Drauoued, I tried to do what you told me. But when i look in the scope the tab allacation isn't availible so I cant select Amout(Eur) into Not Allocated. Cheers, MiRRo
  13. MiRRo

    tr1901 A BEFORE rollup cant be defined............................

    Hi Draoued, Yes this will resolve my problem but in my report I need Amount(Eur) as before rollup and not as after rollup. Is there a way to define amount as before rollup with no errors in transformer. Thx for your reply. Cheers, MiRRo
  14. MiRRo

    tr1901 A BEFORE rollup cant be defined............................

    Hi people, I am getting this error and dont know how to handle with. Can please someone tell me how to resolve this error. TR1901 A BEFORE rollup cant be defined for an allocated measure. (Amount (Eur)) in d:\temp\paimentstest.mdc Thx in advance, MiRRo
  15. MiRRo

    Why should I use a macro??

    Hi Lex, Thx for your macro's but it is not so easy as I thought. If we take the macro about custom exceptions that you wrote for Cognos11 as example. My first question. - I have an report named Segmentanalyse.ppr so I should think the macro has to be like this. Where do I have to fill my report...
  16. MiRRo

    i have a ppr report which looks lik

    Hi Lex, Thx for your macro's but it is not so easy as I thought. If we take the macro about custom exceptions that you wrote for Cognos11 as example. My first question. - I have an report named Segmentanalyse.ppr so I should think the macro has to be like this. Where do I have to fill my report...
  17. MiRRo

    Why should I use a macro??

    Hi drlex, I am now interested in macros for my reports, like you said a macro for distrubuting reports is interesting. What kind of posibilities can be there still particularly for my reports? Because I am new for macros its a little bit difficult for me to imagine the posibilities. If it is...
  18. MiRRo

    Why should I use a macro??

    Hi, I have build 5 cubes and over 40 reports. I use impromptu only for iqd's and we dont use upfront. I think its now the time for me to learn writing macro's. Here is my question. Can some one tell me why I should use a macro and what is the best way to learn writing macro's. Thx! Cheers, MiRRo
  19. MiRRo

    TR1901 The number of children..........

    Hi Bruce & flex, Thx for your reply. Yes Bruce I really have over 65000 children per parent. No Bruce I am not at office I am home now :-). It's now 21.20 o'clock here. Tomorrow I will ad another level(which has no children over 65000) and hope this will help. I will lett you know the result...
  20. MiRRo

    TR1901 The number of children..........

    Hi Bruce, How do I know wicht dimension causes the error? Cheers, Murat

Part and Inventory Search

Back
Top