CALUMO
CALUMO is a Business Intelligence and Business Performance Management web and Microsoft Office based application delivering easy to build Reporting, Budgeting and Forecasting applications.
Do you have an idea, suggestion or feedback based on your experience with CALUMO? We’d love to hear your thoughts.
-
Reflex to optionally exclude headers
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 voteWithout 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.
-
New CSTITCH excel formula
I'd like to see a new formula that stitches together a region in excel into a variable string. For instance:
Age 30
Gender Male
Weight 96When 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 voteMuch of this functionality is provided by three existing CALUMO functions:
https://help.calumo.com/CCONCAT/
https://help.calumo.com/CRANGETOJSON/
and
https://help.calumo.com/CURL/ -
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 votesSetting 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.
-
CmemberChildCount Formula
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 voteThis is quite an esoteric requirement, and can be achieved using a CGETMDX function with a query like:
with member measures.childCount as
axis(0).item(0).item(0).children.count
select
[Date].[Fiscal Periods].[Fiscal Year].&2014 on 0,
measures.childCount on 1
from
Cube -
If we pin the Library, can any reports then shift to the right.
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 same
3 votes -
Add a function that derives the Key value from a well formed UID
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 retrieves images or pdf from the DB when published image can be viewed
excel function that retrieve images or pdf from a DB . Then we can view images on the web when the excel file is published.
Example
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 votesCALUMO already allows you to download files stored in the CALUMO library using:
https://help.calumo.com/CINFO/#userfileurlAnd to embed an image using:
https://help.calumo.com/CHYPERLINK/#usage-scenarios (setting the link text to the URI)
- Don't see your idea?
