Add a new parameter to the reflex formulas to exclude the header lines. Most of the time the default headers are inadequate and need manual fixing which is painful. Alternatively a report-wide setting could be added to CREPORTPROPERTIES to exclude headers from every reflex on the page.1 vote
Without tuple information (row and column “headers”) MDX result sets have little meaning. Hiding or suppressing these rows or columns can be achieved using the CREPORTGROUP() function.
I'd like to see a new formula that stitches together a region in excel into a variable string. For instance:
When stitched, it will produce "@Age=" & $B$7 & ",@Gender=" & $B$8 & ",@Weight=" & $B$9
An additional parameter could indicate if the stitching was for a cube cell address, Stored Procedure parameters, URL or JSON.1 vote
Data dump. UI to filter the OLAP Dims attributes then return a csv file. Generally used for large data sets.
Develop a UI to filter the OLAP Dims attributes then return data dump as a csv file.
Generally used for large data sets.3 votes
Setting up a CALUMO editable table against the table or view which drives your dimension may be the simplest way to achieve this.
CALUMO Editable tables allow for “Export to Excel” with zero configuration.
new formula to return the number of children for the selected member.
Useful when you you cget and want to find cross data point that doesn't exist.1 vote
This is quite an esoteric requirement, and can be achieved using a CGETMDX function with a query like:
with member measures.childCount as
[Date].[Fiscal Periods].[Fiscal Year].&2014 on 0,
measures.childCount on 1
If the Library is pinned, it obstructs the user being able to read reports.
I'd like to see the report shift to the right of the Library so both can be seen in full at the same3 votes
Have a formula "CREPORTKEYFROMUID(cellref)" that would return just the key value from the UID. The equivalent of '=MID(cellref,FIND(".&[",cellref)+3,LEN(cellref)-FIND(".&[",cellref)-3)".3 votes
excel function that retrieve images or pdf from a DB . Then we can view images on the web when the excel file is published.
We can use it as a fax viewer.We use SSIS to store all the fax PDF into DB with a ref Name then can be viewed on web report. CALUMO.
Also can be used to store documentation, receipts and invoices.8 votes
CALUMO already allows you to download files stored in the CALUMO library using:
And to embed an image using:
https://help.calumo.com/CHYPERLINK/#usage-scenarios (setting the link text to the URI)
- Don't see your idea?