CurrentDate() not what you think in Web Intelligence

In Web Intelligence there are a variety of helpful date functions that you can use. 2 in particular are CurrentDate() and CurrentTime(). You would think that CurrentDate() returns just the current date and CurrentTime() returns the current datetime. However both return the exact same result which makes it confusing, especially if you are using date dimensions where the time is stripped off. The funny...

April 10th, 2017 by David Lai 

Custom BW hierachy level selection in WEBI

Connecting to BW using a BICS connection in WEBI is pretty cool, but unfortunately the ability to select a desired level from a hierarchy proves to be very difficult without any tricks. A common request that I’ve been finding from clients these days is the ability to select a desired level in a hierarchy and not have to expand all the way through in order to see that level. (more…)
April 8th, 2013 by David Lai