Fullclient Report (6.5)

building reports desktopintelligence
1

Hi All,

I have using webi(6.x) report ,In my report having

accno trans date transdetail xxxx xxxx

123 12/10/08 buy xxxxxx
123 13/10/08 buy shoe xxx
123 18/10/08 trans toxxx
124 08/10/08 brought xxx
124 19/10/08 buy xxxx

125 10/10/ 08 buy clothesxxxxx
126 07/08/08 buy xxxxxx

this is report fields. i need each accno’s latest/last transdetail only.
i need to perform calculation or variables report itself only not in query panel. Pls Help me…

I Need result

accno trans date transdetail xxxx xxxx

123 18/10/08 trans toxxx
124 19/10/08 buy xxxx
125 10/10/ 08 buy clothesxxxxx
126 07/08/08 buy xxxxxx

Thanks in Advance,
GGs

Arasu (BOB member since 2008-10-24)

2

Well. Go through this thread

Jansi :india: (BOB member since 2008-05-12)

3

HI Jansi,

Thanks , but i don’t have any mesure values. I have only accno, date and trans detail and some dimension objects. In this case what to do? and i need this result in webi6.x.

Thanks and Regards,

GGs

Arasu (BOB member since 2008-10-24)

4

Even you can do this without measures. But there is no fold option in Web-I.

Jansi :india: (BOB member since 2008-05-12)

5

Hi Jansi,

Do you have any idea to resolve this task using webi6.x. Coz i want to resolve this ticket within 2 hour for high priorty.

Thanks,

GGS

Arasu (BOB member since 2008-10-24)

6

Why don’t you try adding a condition in the query itself? Right now I am not having Web-I access.

Jansi :india: (BOB member since 2008-05-12)

7

But I guess you asked for a full client report initially.
Are you sure its to be done in a webI report or a full client report viewed in webI portal?

.

haider :es: (BOB member since 2005-07-18)

8

HI haider,

I need this one webi6.x only.
I have done using calculation in fullclient(6.5).But client need webi6.x only.

Thanks,
GGS

Arasu (BOB member since 2008-10-24)

9

Jansi,

I have performed fullclient 6.5 using calculation in query panel. But i need result webi6.x only.

Thanks,
GGS

Arasu (BOB member since 2008-10-24)

10

I had done this once in an XI webI report, see if it works for 6x as I am not sure of the if statement available in webI 6x

Apply break on acctno and create a variable for max of tran date object to be shown on the break footer as

=Max([trandate]) In ([acctno])

Assign a variable name to it as max_trandate
To display trandetail column on the break footer, use

=Min( If([trandate]=[max_trandate]; [trandetail]))

Since fold on break does not exist in webI, try removing the trandetail and trandate columns from the block using delete button from keyboard.
Then do a white-on-white font for acctno column and decrease width to the minimum.

.

haider :es: (BOB member since 2005-07-18)

11

Hi Haider,

When i create the variable =Min(If([PTSK Work Info Create Date]=[max_tran];[PTSK Work Info Notes])).i got this error message
“syntax error in formula at possion 71:”"""(error:wis10001)"
[/img]

Arasu (BOB member since 2008-10-24)

12

Have you first checked if the function if() is supported in your version of webI.
Also give the expression used for creating [max_tran] variable

.

haider :es: (BOB member since 2005-07-18)

13

yes if function is working in webi6.x.
Max_trans=Max([PTSK Work Info Create Date]) In ([PTSK Task ID])

Arasu (BOB member since 2008-10-24)