SAP BPC 10 for NW: How to generate on demand SEQ number (Data Manager package)

[former_member239899]

Hi all,

I´m looking for a procedure or program that allows to generate manually (on demand) the sequence number (SEQ number) of the execution of a BPC package, in a similar way as SAP does it automatically.

Does anyone know if this can be done, and with what program / procedure?

Thank you very much and regards, Juan.

[former_member239899]

Hi Vadim,

For example, Excel RANDOM function. Returns a random real number greater than or equal to 0 and less than 1, evenly distributed. Each time you calculate the spreadsheet, it returns a new random real number.

If I know the function that SAP invokes each time that a BPC package is executed, I be able to generate as many SEQ number as I want.

Not for fun... only for run... (generate a SEQ number manually).

Regards, Juan.

[former_member186338]

Sorry, but still no explanation what for? Why do you need to generate SEQ numbers?

Just for fun?

[former_member186338]

P.S. The answer how to generate is very simply, but it’s useless without understanding “what for”!

[former_member239899]

Hello Vadim,

I don´t need to use the SEQ number with HP LoadRunner ... I just need to know how to GENERATE it manually (if possible) ... what is done with this SEQ number with HP LoadRunner is no longer part of the post.

Thank you very much for your guidance.

Regards, Juan.

[former_member186338]

What for? Just for for fun or for some reason?

[former_member239899]

Hello Vadim,

Yes, the GUID is unpredictableby definition (pseudo random number), but it´s not about knowing the GUID, but the ALGORITHM that creates it ...

In this way, the algorithm could be invoked to generate as many SEQ (GUIDs) as needed for the HP LoadRunner application.

Thank you very much for your help.

Regards, Juan.

[former_member186338]

Sorry, but I am unable to understand how do you want to use SEQ with LoadRunner. Please provide step by step example.

[former_member239899]

Hello Vadim,

I also don´t know how HP LoadRunner wants to use the SEQ number ... the question I have been asked (this is the post) is to find out which program / process SAP uses to generate this number ... (what they do next with it, I don´t know ...)

Yes, I think, as you, that SEQ number is an internal BW GUID... but my question is to know how this number is generated by the SAP process.

Thank you for your help.

Regards, Juan.

[former_member186338]

GUID is unpredictable by definition! Do you understand what I mean?

[former_member186338]

Sorry, but I am unable to understand how this SEQ can be used with LoadRunner. To my mind SEQ is some kind of GUID. Please read wiki about guid...

[former_member239899]

Hello Vadim,

In our system, we want to test the workload of the execution of several packages from BPC, through the HP LoadRunner software (Hewlett Packard Enterprise). For your information, you can see:

https://en.wikipedia.org/wiki/LoadRunner

To do this workload simulation, from HP LoadRunner we are asked to know the algorithm that SAP uses to generate this package execution ID (SEQ number).

And then, the problem is that this ID (SEQ number) is not known until the package is executed (SAP generates it automatically, I do not know based on what algorithm).

The question then is TO KNOW what algorithm SAP uses to generate the number SEQ, and to be able to make simulations of executions of packages from HP LoadRunner.

Is this possible (generate this SEQ number on demand)? (this is the question).

Thank you very much and regards, Juan.

[former_member186338]

There is no way to generate this number. But what for? What do you want to achieve???

P.S. What do you mean by generate??

[former_member239899]

Hi Vadim,

Please see:

http://www.igniteideasandinspirations.com/question/sap-bpc-10-nw-link-package-seq-number-data-manage...

SEQ number in BPC Data Manager is the "Sequential number" that SAP automatically generates when you execute one BPC package.

If you need any other clarification please tell me.

Thank you, Juan.

[former_member186338]

What do you mean by SEQ number???