Well, I guess the team at Oracle was listening to someone. I just looked at the release notes for EPM Fusion Edition 11.1.1.3 and there plain as day is the bug fix
Data Extraction. While exporting data to a relational database, DATAEXPORT does not create thedelimiters if there are one or more missing values in the last column. [8507606]
Another problem I was getting at a client was when I would remote onto a server using the consloe option, when I logged of the Essbase application would hang. That apparently has been fixed as well
Agent. When Essbase is running as a Windows service and the domain user logs off the machine,
the Essbase applications hang, which in turn causes Essbase Server to hang. [8279377, 8464004]
While I worked around both of these problems, Its nice to know I won't have to in the future
ODI in the hybrid database world – Amazon Redshift – AWS CLI
-
Written on June 5, 2023 by Rodrigo Radtke de Souza Hi all, probably this is
the last post of this series on how to load data from on-premises databases
to ...
1 year ago
Posts
5 comments:
Glenn:
I developed a calc script to export data from a HP app using the DATAEXPORT command. I also scripted a clear, import and aggregation of this data into an ASO app. Everything works like a charm. But can users get locked out of HP during the export process? Same question applies during import and agg in ASO.
Thanks!
-Tom G.
This is a calc script and unless you have commited access turned on users should be able to access the cube while the export is occuring. For ASO cubes you don't mention what version you are on. In version 7 users would get locked out during loads. In System 9 (9.3.1 and higher) and Version 11 yo can access while loads occur. You could always get data while aggregations are occuring, they are just slower than if the agg is complete
Both HP and the underlying Essbase engine and v11. So I'm in good shape. Going to look into having "committed access turned on."
Thanks Glenn!
-Tom G.
I'm using essbase 11.1.1.3.
I'm using the calc script (DataExport to generates the export)
DATAEXPORT "DSN" "ODBC" "teste" "usuario" "senha"
I'm generating my cube exporting in a table of my database sql server 2005.
The problem is that this exporting generates a dimension as a PAge, and I can't put this dim page on my database... Is that possible?
Can I generate export without this dim page?
Is it not possible export to the database all dimensions, including all dense dimensions?
My dimension account and period are dense.
I cant put on my table of my relational database these dimensions using dataexport?
Thanks,
Leo.
I'm afraid at least one of the dense dimensions has to be the columns. Some have gotten around the restriction by adding a single member dense dimension to the outline and using that as the column. This would be difficult to implement if it is a well established cube as every load,report, excel retrieval would need to be changed.
Post a Comment