Session time out when multiplying report variables

building reports webintelligence
1

HI,

When I create a report level variable(Say X) by multiplying 2 other report level variables(Say Y and Z) , it is throwing a session timeout error when I use the X in my report.

The formula used in the reportlevel variables are,

Y=ToNumber(FormatNumber([FuturePrice].[Regular Value - No aggregation] Where( [FuturePrice].[Name]=“Shirt Price”);"###.##"))

Z=Sum(If([Data].[Name] InList(“Bulk Market”;“Bulk Market - Daily”);[Size];0)) In ([Data].[Month];[Data].[Year])/[Total Days in Month]

X= Y*Z/100.

If I use X in my report it it throwing “Session timed out.Error : WIJ60001)” error.

Please let me know what is the problem.

bak (BOB member since 2010-09-30)

2

Hello, bak!

I had a similar issue to yours a couple of weeks ago and here is the link to the corresponding thread I created.

https://bobj-board.org/t/166350

We have yet to find a solution to our issue. Maybe we should join forces ; )

Hafsolace :estonia: (BOB member since 2010-08-27)

3

Thanks for the reply. Is there any work around to fix it. Also if I remove the where clause of Variable Y it works fine.

Y=ToNumber(FormatNumber([FuturePrice].[Regular Value - No aggregation]);"###.##")).

I dont know why :frowning:

bak (BOB member since 2010-09-30)

4

Bak

Did you find a workaround/resolution to this problem? I am investigating the same issue with reports & universe created by somebody else, and see that they too are using rather complex formula in report variables, multiplying etc. report variables… Did you try moving the complexity down a level i.e. putting the complex manipulations in the universe (e.g. in derived tables) or in the database (in views)? FWIW - that’s the way I’m currently thinking, but keeping an open mind for other solutions.

rodlangham :uk: (BOB member since 2004-04-13)