GetNumsAB
A brand new, high-performing, "GetNumbers" or "fnTallyTable" function that can be used for defeating RBAR.
2020-07-02 (first published: 2016-03-23)
1,079 reads
Itzik Ben-Gan
Missing cell value in Excel with pivottable and cubes
Hello! I have pivot tables in Excel witch uses cubes in Analysis Services as data source. In some cells I don't get any figures for the measures. What I get is "#Saknas!" (Swedish so I guess if one have an English version it would be "#Missing!". But when I look in the cube there are […]
2005-04-25
4 reads
RE: Saving DTS Packages
What I've done is to open each package in design view and save it off as a VB Script. Then, when I need to bring them back in, I either run the script from VB or from Access.To run the packages from either VB or Access, you need to set the references to Microsoft DTS […]
2004-09-30
RE: Exotic use of User Defined Function
As I pointed, it will be more than 999 number of records in a table.Column data must be assigned automatically by the database. No one wants to rebuid the applications. Anyway any mechanism must create a value and place it as default for the column.User defined function is set the value by default if NULL is […]
2004-09-29
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers