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...
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.
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...
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...
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
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
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
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
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...
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...
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...
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
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.