Skip to Content
author's profile photo Former Member
Former Member

Routine to count unique data records.

Hello,

I am doing flat file data uploading into the InfoCube. One InfoObject is that of the TICKET_ID. I have another InfoObject

which counts the number of tickets ie. for each unique Ticket ID the count of ticket should be equal to one.

However in the flat file the TICKET_ID repeats multiple number of times. I want to write a routine in the transformation which maps the TICKET_ID to the number of tickets. For each of the unique ticket ID the Number of Ticket should be equal to one. For the TICKET_ID's repeating the number of ticket should be equal to one.

Can you please help me out with the routine.

Thanks in advance.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 04, 2008 at 01:55 PM

    No need for routine

    Create a KF for count of ticket

    In the Business Explorer tab for creation of infoobject count of ticket give Aggregation as SUM, exception aggregation as Counter of all values and give aggregate reference charecteristics as Ticket ID

    Upload the data in cube, execute the report. Results will be matching the count on flat file data

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hello,

      I cant take the data into an ODS this is because my flat file looks like this:

      TicketID Hours per Ticket

      HD0001 2.30

      HD0001 6.00

      HD0002 21

      HD0002 15

      HD0002 9

      HD0003 0.30

      HD0004 0.45.......................

      If i create an ods with TicketID as key field there will be an error in calculating the total hours per ticket.

      What i want to display in the cube is as follows:

      TicketID Hours per Ticket No of Tickets

      HD0001 2.30 1

      HD0001 6.00 0

      HD0002 21 1

      HD0002 15 0

      HD0002 9 0

      HD0003 0.30 1

      HD0004 0.45 1

      Thanks.

  • author's profile photo Former Member
    Former Member
    Posted on Jan 07, 2008 at 08:10 AM

    hi

    Have u got the solution or not??

    Still u can try in front end itself....May be u try this way...

    Create a selection & add ur char in tht & then create a KF with tht selection & found a counter...

    Chk it out..

    Cheers

    BI Learner

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.